Bookstore Inventory

EASY Other 49 questions

A sample bookstore inventory with 10 books.

0
Columns
5+
Sample Rows
Aug 2025
Last Updated
8%
Completion Rate

Practice Questions

1

Find the average price of all books.

EASY Aggregate 5 pts
8 attempts 12.5% success
2 hints available
Start Solving
2

Count books in "Sci-Fi" genre

EASY SELECT 5 pts
5 attempts 60.0% success
Start Solving
3

List authors without duplicates

EASY SELECT 5 pts
7 attempts 71.43% success
Start Solving
4

Find most expensive book

MEDIUM Aggregate 10 pts
1 attempts 100.0% success
Start Solving
5

Total stock quantity

EASY Aggregate 5 pts
0 attempts 0% success
Start Solving
6

Find books published in the same year as "The Great Gatsby"

EASY Subquery 10 pts
1 attempts 0.0% success
2 hints available
Start Solving
7

Show books with price above average and their genre information

MEDIUM Subquery 15 pts
0 attempts 0% success
2 hints available
Start Solving
8

Rank books by price within each genre

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
9

Find the most expensive book in each genre using window functions

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
10

Calculate cumulative price by genre using window functions

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
11

Find books with above-average pages using CTE

MEDIUM CTE 15 pts
0 attempts 0% success
2 hints available
Start Solving
12

Count books by genre and show only genres with more than 1 book

EASY Aggregate 10 pts
0 attempts 0% success
2 hints available
Start Solving
13

Find average price by publication decade

HARD Aggregate 20 pts
0 attempts 0% success
2 hints available
Start Solving
14

Find the most expensive book in each genre using FIRST_VALUE

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
15

Show books with their percentile rank within their genre

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
16

Find books with the highest and lowest prices in each decade

HARD Window Function 20 pts
0 attempts 0% success
3 hints available
Start Solving
17

Find books that are more expensive than the average of the top 5 most expensive books

HARD Subquery 20 pts
0 attempts 0% success
3 hints available
Start Solving
18

Find books with price above the 75th percentile in their genre

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
19

Show books with their price rank within each genre

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
20

Find genres with average price above $15

MEDIUM Aggregate 15 pts
0 attempts 0% success
2 hints available
Start Solving
21

Calculate total pages by genre

EASY Aggregate 10 pts
0 attempts 0% success
2 hints available
Start Solving
22

Find books published between 1950 and 2000

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
23

Find books by authors whose names start with "G"

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
24

Show books with their price rank within genre using window functions

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
25

Find books with price above genre average using subquery

HARD Subquery 20 pts
0 attempts 0% success
2 hints available
Start Solving
26

Show books with their publication decade

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
27

Find the most expensive book in each genre using window functions

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
28

Calculate cumulative price by genre using window functions

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
29

Find all Fiction books

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
30

Show books with price above $15

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
31

Find books with more than 300 pages

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
32

Show books published after 1950

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
33

Find books by authors whose names start with "H"

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
34

Count total number of books

EASY Aggregate 10 pts
0 attempts 0% success
2 hints available
Start Solving
35

Find the most expensive book

EASY Aggregate 10 pts
0 attempts 0% success
2 hints available
Start Solving
36

Find genres with more than 1 book

MEDIUM Aggregate 15 pts
0 attempts 0% success
2 hints available
Start Solving
37

Find books with price exactly $12.99

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
38

Show books with pages between 200 and 400

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
39

Find books by authors whose names end with "n"

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
40

Show books with price less than $15 and pages more than 250

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
41

Find the book with the most pages

MEDIUM Subquery 15 pts
0 attempts 0% success
2 hints available
Start Solving
42

Show books with their genre average price using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
43

Find books with similar prices using self-join

MEDIUM JOIN 15 pts
0 attempts 0% success
3 hints available
Start Solving
44

Show books with their publication decade using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
45

Find books with above-average pages in their genre using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
46

Show books with their genre ranking using window function and join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
47

Show books with their genre statistics using multiple joins

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
48

Find books with similar publication years using self-join

MEDIUM JOIN 15 pts
0 attempts 0% success
3 hints available
Start Solving
49

Show books with their genre percentile using window function and join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving

Dataset Overview

Description

A sample bookstore inventory with 10 books.

Key Features

  • EASY difficulty level
  • OTHER category
  • 49 practice questions
  • 0 downloads
  • 0.0 average rating

Schema & Sample Data

Sample Data (First 3 Rows)

id genre price title author published_year stock_quantity
1 Mystery 14.99 The Silent Echo Elena Rivera 2020 12
2 Sci-Fi 19.99 Beyond the Hori… Marcus Lee 2022 3
3 Fantasy 12.49 Crimson Winter Sophia Chen 2018 0
4 Technology 24.99 Data Dreams Alex Johnson 2023 25
5 Sci-Fi 15.5 Echoes of Time Marcus Lee 2019 7

Related Datasets

Employee Management System

EASY

Comprehensive SQL practice dataset with employee data covering all major SQL SELECT concepts

53 questions 0 downloads
View Dataset

Corporate Employee Directory

MEDIUM

A corporate employee directory with 10 employees for SQL practice.

50 questions 0 downloads
View Dataset

Statistics

0.7%
Avg Score
49
Questions
0
Downloads
8%
Completion
Easy Questions
3/49
Medium Questions
3/49
Hard Questions
43/49