Skip to content

Learn Functions Examples Practice Interview Cheatsheet Blog Playground

easy problems

List Active Customers Actors Born After 1985 Authors From the USA Average Product Price Book Title Search Books Published After 2015 Fiction Books Cheapest Product Completed Orders Only Count All Movies Count Customers Count Employees Per Department Count Pending Orders Distinct Customer Cities Customers in Seattle Customers by Signup Date List Departments Distinct Book Genres Employee Full Names Employees by Hire Date Employees in Engineering Lowest Paid Employee Highest Salary Drama Movies Movies With 'The'Movies After 2018 Movies Released Since 2020 Newest Movie Products Above $50 Electronics Products Product Count by Category Select Active Customers Student Names Starting A Students by Grade Level Students Enrolled in 2021 Students in Grades 10 and 11 Total Product Stock Top Paid Employees Total Store Revenue

Home

Fiction Books

easylibrarywhere

Fiction Books

Problem

Return title and author_id of books where genre is 'Fiction', ordered by title.

Try It

Loading playground environment...

Hint

Solution

On this page

Problem
Try It
Hint
Solution

The definitive resource for learning SQL, from your first SELECT to advanced window functions, with a real database running in your browser.

Learn Functions Examples Practice Interview Cheatsheet Blog Playground About Contact

© 2026 SQLSimplified. Learn SQL by doing.