...
| 代码块 | ||||
|---|---|---|---|---|
| ||||
select p.pname as Project项目,it.pname as 'Issue Type'问题类型,count(*) as Count计数 from jiraissue ji join issuetype it on ji.issuetype=it.id join project p on p.id=ji.project group by p.pname,it.pname; |
...
...
| 代码块 | ||||
|---|---|---|---|---|
| ||||
select p.pname as Project项目,it.pname as 'Issue Type'问题类型,count(*) as Count计数 from jiraissue ji join issuetype it on ji.issuetype=it.id join project p on p.id=ji.project group by p.pname,it.pname; |
...