/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

0 vote198 views1 answer
Postgresql create table many-to-many
SQL
1 vote226 views1 answer
Add sequence postgres
SQL
0 vote200 views1 answer
Downgrading sql localdb visual studio
SQL
4 votes194 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
2 votes198 views3 answers
How to pass password mysql command line
SQL
2 votes215 views3 answers
How to check current user in mySQL
SQL
0 vote279 views1 answer
Varchar2 length in oracle
SQL
1 vote204 views1 answer
Postgresql define pk sequence next number
SQL
0 vote215 views1 answer
How to increase the width of the screen in oracle
SQL
22 votes238 views3 answers
Sql cheat sheet
SQL