59

Popular Book Authors

MediumJOINCOUNTGROUP BY

Problem Description

Write a SQL query to find authors whose books have been borrowed more than once.

Expected Columns

author
borrow_count

Example Output

| author | borrow_count | |--------|--------------| | R.K. Narayan | 3 | | A.P.J. Abdul Kalam | 2 |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

Related Topics

JOINCOUNTGROUP BYHAVING

//#59 Popular Book Authors

Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results