/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

8 votes90 views3 answers
Duplicate entry
SQL
0 vote112 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote132 views1 answer
Php insert null mysql
SQL
0 vote100 views1 answer
Difference between varchar and varchar2
SQL
3 votes216 views6 answers
Sql unique select
SQL
0 vote125 views1 answer
Sql server information_schema temp tables
SQL
7 votes101 views1 answer
Append column sql
SQL
1 vote94 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote115 views1 answer
Trim leading zeros in sql
SQL
18 votes102 views4 answers
Uninstall mysql on ubuntu
SQL