/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 vote203 views1 answer
Sql how to get courses that i have made prerequisites
SQL
-2 votes218 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote206 views1 answer
Transaction database with php
SQL
2 votes219 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
6 votes214 views6 answers
Rename column postgres
SQL
3 votes202 views4 answers
Show databases in sql server
SQL
0 vote188 views1 answer
Mysqldump ignore table
SQL
0 vote143 views1 answer
Connection error in mysql workbench
SQL
0 vote253 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote208 views1 answer
Plsql check how much space all databases are consuming
SQL