All Problems
75

Genre-wise Book Availability

MediumSUMGROUP BY

Problem Description

Write a SQL query to find total copies available by genre.

Expected Columns

  • genre
  • total_copies

Example Output

| genre | total_copies | |-------|--------------| | Fiction | 19 | | History | 5 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#75 Genre-wise Book Availability
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results