Project 25: Active Chat Channels
SQL Architect
Query Task
Objective
Review day: combine GROUP BY and HAVING — days 19 and 20 — to find channels with real activity.
You're given a messages table with columns id, channel, sender, and sent_at.
Task: return channel and a count of messages, grouped by channel, keeping only channels with more than 50 messages.
query.sql
SELECT channel, COUNT(*) FROM messages GROUP BY channel HAVING COUNT(*) > 50;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results