TicketSalesAnalysis

SELECT 'category' AS table_name, COUNT(*) AS record_count FROM category
UNION ALL
SELECT 'date', COUNT(*) FROM date
UNION ALL
SELECT 'event', COUNT(*) FROM event
UNION ALL
SELECT 'listing', COUNT(*) FROM listing
UNION ALL
SELECT 'sales', COUNT(*) FROM sales
UNION ALL
SELECT 'users', COUNT(*) FROM users
UNION ALL
SELECT 'venue', COUNT(*) FROM venue;

SELECT * 
FROM category