/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 vote143 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote142 views1 answer
Mariadb get column names from table
SQL
3 votes135 views1 answer
How to remove characters from string in mysql
SQL
0 vote151 views1 answer
Create table split string function in sql server
SQL
3 votes161 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
3 votes134 views1 answer
Oracle list user grants
SQL
0 vote156 views1 answer
How to change mysql root password in windows 10
SQL
0 vote136 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote262 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote153 views1 answer
Mysql select all where count more than"
SQL