/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 vote208 views1 answer
Gcloud sql instance list
SQL
1 vote217 views1 answer
Postgres set sequence value to max id
SQL
0 vote210 views1 answer
Postgresql get diff between two dates in Months
SQL
2 votes203 views1 answer
Brew start postgres manual
SQL
0 vote191 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
15 votes210 views3 answers
Postgresql change column type
SQL
1 vote201 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote183 views1 answer
Mql5 list all available symbols
SQL
1 vote206 views1 answer
How to see logical reads in sql server
SQL
9 votes211 views1 answer
Oracle get table schema
SQL