/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 vote246 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote246 views1 answer
Mysql update sum same table
SQL
0 vote259 views1 answer
Get week day name sql server
SQL
4 votes254 views1 answer
Mysql ip address
SQL
0 vote260 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote284 views1 answer
Savepoint mysql script
SQL
0 vote246 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote274 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote252 views1 answer
How to avoid duplicate records in sqlite
SQL
-1 vote271 views1 answer
Get id from just inserted row mysql server python
SQL