Works published more than 5 times
Works published more than 5 times
Cian uses a training library schema as practice before the real tasks on listings. The point here is to check how you work with joining tables, grouping and filtering groups. Find the works that came out in more than five editions, and for each such work return the total number of editions.
Expected output sample
| work_id | title | edition_count |
|---|---|---|
| 6 | Fathers and Sons | 7 |
| 3 | Anna Karenina | 6 |
| 1 | War and Peace | 6 |
Cian
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid