/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 vote133 views1 answer
Set mysql mode global query
SQL
3 votes132 views1 answer
Oracle revoke grant
SQL
0 vote135 views1 answer
Set a default value for a column in sqlite
SQL
2 votes124 views1 answer
Wait delay in sql server
SQL
0 vote148 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote90 views1 answer
How to see the content of tables in pgadmin
SQL
2 votes134 views1 answer
Mysql add boolean column
SQL
14 votes141 views2 answers
Oracle add attribute to table
SQL
2 votes179 views1 answer
How to select from mssql
SQL
0 vote153 views1 answer
Sql remove non numeric characters
SQL