Works published more than 5 times
Cian gives candidates a tiny library schema as a warm-up before the real listing-based questions: it tests only JOIN + GROUP BY + HAVING. The task is to find works with a rich publishing history.
Find works with more than five editions and, for each, return the total edition count.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| title | work_id | edition_count |
|---|---|---|
| Fathers and Sons | 6 | 7 |
| Anna Karenina | 3 | 6 |
| War and Peace | 1 | 6 |
Cian
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid