here its showing error for i.account_id couild you pease check whats wrong here SELECT a.username, a.email, COUNT(i.id) AS items, SUM(i.weight) AS total_weightFROM accounts aJOIN items i ON a.id = i 1 answer