25

Books by Genre

EasyCOUNTGROUP BY

Problem Description

Write a SQL query to count how many books are in each genre.

Example Output

| genre | book_count | |-------|------------| | Fiction | 4 | | History | 2 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#25 Books by Genre
Easy

Loading schema...

Loading editor...

No results yet

Run a query to see results