让sql子查询停止抱怨重复的列

so suppose I have this query

假设我有这个查询。

SELECT COUNT(*) FROM (SELECT * FROM k JOIN j ON k.id = j.aid) k 
SELE