/SQL/Sql script to get a type task on jira datbase for 12 months

Sql script to get a type task on jira datbase for 12 months

SELECT p.pkey, it.pname, COUNT(i.id) FROM jiraissue i INNER JOIN project p ON i.project = p.id INNER JOIN issuetype it ON it.id = i.issuetype GROUP BY (p.id, it.id) ORDER BY p.pkey, count DESC;

Source: confluence.atlassian.com

Similar codes

1 vote161 views1 answer
How to see all table partition in oracle
SQL
0 vote168 views1 answer
Postgresql delete multiple rows
SQL
7 votes177 views1 answer
Oracle pagination query rownum
SQL
0 vote168 views1 answer
Selecting Data in SQL - Select Data
SQL
2 votes224 views1 answer
Remove foreign key constraints in postgres
SQL
7 votes168 views1 answer
Sql server convert string to date
SQL
0 vote215 views1 answer
Mysql create index lost connection
SQL
0 vote165 views1 answer
Sqlcmd no headers
SQL
3 votes168 views2 answers
Current year sql
SQL
-1 vote160 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL