Untitled

SELECT 
    s.username,
    COUNT(cs.id) AS total_streams,
    FLOOR(AVG(cs.viewers)) AS avg_viewers
FROM 
    streamers s
JOIN 
    completed_streams cs ON s.id = cs.streamer_id
GROUP BY 
    s.id
HAVING 
    COUNT(cs.id) > 5 AND AVG(cs.viewers) > 5000
ORDER BY 
    FLOOR(AVG(cs.viewers)) DESC;