mysql - #1060 - Duplicate column name 'id'

Question

Why I get #1060 - Duplicate column name 'id'

SELECT COUNT(*) FROM (SELECT * FROM `tips` `t` LEFT JOIN
tip_usage ON tip_usage.tip_id=t.id GROUP BY t.id) sq

Answer 1

Probably because the * in select * selects two columns with the same name from tip_usage and tips.