GROUP BY
GROUP BY
In MySQL, the GROUP BY clause is used to group rows that have the same values in specified columns. This is often used in conjunction with aggregate functions, such as COUNT, SUM, AVG, MAX, or MIN, to perform calculations on each group of rows.
Syntax
SELECT column1, column2, FROM table_name WHERE condition GROUP BY column1, column2;
Example
Suppose we have a Students table as shown below:
Now, suppose you want to find out how many students are enrolled in each subject. In order to do this, we formulate the following query:
SELECT course, COUNT(*) AS student_count FROM Students GROUP BY course;
SELECT course, COUNT(*) AS student_count
FROM Students
GROUP BY course;The result of this query would be a table showing the count of students for each course:
🤖 Don't fully get this? Learn it with Claude
Stuck on GROUP BY? Open Claude, copy a block below, and it'll teach you this exact concept — visually and interactively.
Build the mental picture, not memorization.
I just read a lesson on **GROUP BY** (Databases) and want to truly understand it. Explain GROUP BY from first principles using ONE vivid real-world analogy and a visual mental model — draw it as ASCII art or a clear step-by-step diagram — with a concrete example using real numbers. Then ask me one question to check I got the mental picture, and wait for my reply. If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.
Socratic — adapts to where you're stuck.
Teach me **GROUP BY** interactively. Ask me ONE guiding question at a time, wait for my answer, and adapt to my confusion — build the idea with me step by step instead of explaining it all at once. If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.
Active recall exposes what you missed.
Quiz me on **GROUP BY** with 5 questions, easy to tricky, ONE at a time. Tell me if each answer is right; at the end, explain clearly what I got wrong and why. If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.
Intuition + hook + flashcards for long-term memory.
Help me remember **GROUP BY** for the long term: give the one-sentence intuition, a memorable hook/mnemonic, a tiny worked example, and 3 active-recall flashcards (Q -> A). If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.