Grouping
Count the number of entries in the customers table for each first_name:
SELECT
first_name,
count(*)
FROM customers
GROUP BY first_name;
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
Count the number of entries in the customers table for each first_name:
SELECT
first_name,
count(*)
FROM customers
GROUP BY first_name;