โ† Oracle questions

Author book sales query

Filed under Oracle

Given a table 'Sales' with columns AuthorID, BookName, Year, and Cost, write a SQL query to retrieve the AuthorIDs of authors who sold more than 3 books in any single year.

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Oracle questions

Collected from public candidate posts and coding forums. Updated Nov 2026.