/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 vote277 views1 answer
Rename table column name in mysql
SQL
7 votes256 views1 answer
Mysql unsafe update
SQL
0 vote281 views1 answer
Change redo log file size in mysql 5.6
SQL
3 votes292 views1 answer
Oracle sleep
SQL
17 votes321 views2 answers
T_sql contains
SQL
0 vote273 views2 answers
Sql server set default value equal to auto increment
SQL
8 votes297 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote292 views1 answer
How to create a table based on another table in mysql
SQL
0 vote275 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote254 views1 answer
Create table employees oracle
SQL