ANALYZE TICKET SALES WITH AI

SELECT u.userid, u.username, u.firstname, u.lastname, u.city, u.state, u.email, u.phone, SUM(s.qtysold) AS total_tickets_sold
FROM users u
JOIN sales s ON u.userid = s.sellerid
JOIN listing l ON s.listid = l.listid
JOIN date d ON s.dateid = d.dateid
WHERE d.year = 2008
GROUP BY u.userid, u.username, u.firstname, u.lastname, u.city, u.state, u.email, u.phone
ORDER BY total_tickets_sold DESC
LIMIT 5;