Database: bike_racing
Question: How many bikes does each cyclist own? Order by cyclist id.
SQL:
SELECT cyclist_id ,  count(*) FROM cyclists_own_bikes GROUP BY cyclist_id ORDER BY cyclist_id