...
| 代码块 | ||||
|---|---|---|---|---|
| ||||
select p.pname as 项目,it.pname as 问题类型,count(*) as 计数 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 项目,it.pname as 问题类型,count(*) as 计数 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; |