Re: Query Problem

[Peter Brawley]

To count the zeroes you need a left join:

SELECT u.name, COUNT( h.name) As fault_count
FROM users u
LEFT JOIN history h USING (name)
GROUP BY u.name
ORDER BY fault_count DESC ;