SELECT 
    e.asset_id,
    a.name AS asset_name,
    COUNT(*) AS event_count
FROM events e
JOIN assets a ON a.id = e.asset_id
GROUP BY e.asset_id, a.name
HAVING COUNT(*) > 0
ORDER BY event_count DESC;