/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 vote212 views1 answer
How to retrive the today date sql
SQL
0 vote215 views1 answer
Sql get month from date
SQL
0 vote222 views2 answers
How to create a table from another table in sql derby
SQL
0 vote210 views2 answers
Find lowest number in sql
SQL
0 vote211 views1 answer
Syntax for changing column size in mysql
SQL
3 votes223 views1 answer
Laravel database Using Named Bindings
SQL
0 vote205 views1 answer
Postgresql regular expression special characters
SQL
0 vote216 views1 answer
Postgresql delete multiple rows
SQL
3 votes244 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote222 views1 answer
Connect by query in oracle
SQL