Global Electronics Store

MEDIUM E-commerce 23 questions

A global electronics store orders dataset for SQL practice.

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

Practice Questions

1

Find products with price above category average

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

Rank products by price within each category

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

Find top 3 most expensive products in each subcategory

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

Calculate price difference from category average using window functions

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

Show products with stock quantity above country average using CTE

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

Find products with highest price in their category and subcategory

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

Calculate total inventory value by country

MEDIUM Aggregate 15 pts
0 attempts 0% success
3 hints available
Start Solving
8

Find categories with average price above $500

MEDIUM Aggregate 15 pts
0 attempts 0% success
3 hints available
Start Solving
9

Show products with their price percentile within category

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

Calculate average price by manufacturer country

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

Find products with price above $1000

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

Show products from USA or Japan

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

Find products with stock quantity below 100

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

Find products in the same category using self-join

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

Show products with their category average price using join

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

Find products with similar prices using self-join

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

Show products with their manufacturer country statistics using join

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

Find products with above-average stock in their category using join

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

Show products with their category ranking using window function and join

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

Find products with highest value (price * stock) in each category using join

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

Show products with their subcategory statistics using multiple joins

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

Find products from the same manufacturer country using self-join

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

Show products with their category percentile using window function and join

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

Dataset Overview

Description

A global electronics store orders dataset for SQL practice.

Key Features

  • MEDIUM difficulty level
  • ECOMMERCE category
  • 23 practice questions
  • 0 downloads
  • 0.0 average rating

Schema & Sample Data

Sample Data (First 3 Rows)

category order_id quantity order_date unit_price product_name customer_name payment_method shipping_country
Electronics 1001 2 2023-05-12 89.99 Wireless Headph… John Smith Credit Card USA
Electronics 1002 1 2023-06-03 129.99 Bluetooth Speak… Emma Johnson PayPal Canada
Wearables 1003 1 2023-05-18 199.99 Smart Watch Raj Patel Credit Card India
Accessories 1004 3 2023-06-21 49.95 Gaming Mouse Luis García Debit Card Spain
Accessories 1005 5 2023-07-05 19.99 USB-C Charger Sophie Martin PayPal France

Related Datasets

No Related Datasets

Explore other datasets in the same category.

Browse Similar Datasets

Statistics

0.0%
Avg Score
23
Questions
0
Downloads
0%
Completion
Easy Questions
3/23
Medium Questions
3/23
Hard Questions
17/23