65

Active Borrowers

MediumJOINWHERECOUNT

Problem Description

Write a SQL query to find members who currently have borrowed books (status = 'Borrowed').

Expected Columns

member_name
books_borrowed

Example Output

| member_name | books_borrowed | |-------------|----------------| | Rajan Iyer | 2 | | Parvati Devi | 2 | | Meghna Roy | 1 | | Sudhir Mishra | 1 |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

Related Topics

JOINWHERECOUNTGROUP BY

//#65 Active Borrowers

Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results