Group by

The GROUP BY statement groups rows that have the same values into summary rows, like "find the number of commits for each username or email".

SELECT * FROM commits GROUP BY name