如何查询找到最大票数的项目？

Question

我做了一个查询，但它不工作：

SELECT project_fk,
       COUNT(*) as tickets
FROM ticket_details
where project_fk = MAX(tickets)

这里我从ticket_details表中提取数据，其中project_fk是一个外键

我使用的mariadb和mysql一样

Answer 1

SELECT project_fk, COUNT(*) as tickets 
FROM ticket_details 
GROUP BY project_fk 
ORDER BY 2 DESC LIMIT 1

如果两个或更多项目具有相同的最大行数，则只会返回一个。