A fresh approach to real estate
SELECT category, COUNT(category) FROM listings WHERE status='current' AND type='residential' GROUP BY category

Got error 28 from storage engine