MySQL Concat 和 GROUP BY

Question

我有 2 个表:People 和 Writings。我想获得写书最多的 3 个人的名单。

表格:

我想找出写书最多的前 3 名人员(书 = 主题)。他们应该按照从多到少的顺序排列(我指的是那三个人)。

我尝试这样做:

SELECT People.Name, People.Secondname,     
  People.City, COUNT( Writings.Author)  AS Kiekis       
FROM Writings, People 
WHERE  CONCAT (People.Name, ' ',People.Secondname) = Writings.Author 
GROUP BY Kiekis DESC LIMIT 3; 

Answer 1

SELECT Author, COUNT(*)
FROM People, Writings 
WHERE CONCAT (People.Name, ' ',People.Secondname) = Writings.Author 
GROUP BY Author 
ORdER BY COUNT(*) DESC 
LIMIT 3

但是表之间的连接确实很奇怪，我的意思是在第一个表中使用author_id会更好。