...
Depending on your SQL writing query skills you can easily choose the most comfortable way to write a query.
For advanced users of SQL language, it might be more comfortable to use our Console, where you have an opportunity to write your own query. Also, you can write a query right in your dashboard gadgets.
If it's more comfortable for you to build a query in a more visual way, where you can see all relative tables of Data from your Jira - Visual Query Builder will help you to construct it in an easy and fast way.
...