SELECT Challenges — 10 Problems

Start simple. Build confidence. These 10 SELECT challenges go from beginner to intermediate. Each one tests a different skill. Try to write the query before looking at the solution.

Challenge 1: All Customers from Mumbai

Find all customers who live in Mumbai. Show their full name and signup date.

SELECT first_name, last_name, signup_date
FROM customers
WHERE city = 'Mumbai'
ORDER BY signup_date;

Challenge 2: Products Under Rs 1000

List all products priced under Rs 1000. Show name, category, and price. Sort cheapest first.

SELECT product_name, category, price
FROM products
WHERE price < 1000
ORDER BY price ASC;

Challenge 3: Completed Orders in June 2024

Find all completed orders placed in June 2024. Show order_id, order_date, and total_amount.

SELECT order_id, order_date, total_amount
FROM orders
WHERE status = 'completed'
  AND order_date BETWEEN '2024-06-01' AND '2024-06-30'
ORDER BY order_date;

Challenge 4: Top 5 Most Expensive Products

Show the 5 most expensive products. Include name, category, and price.

SELECT product_name, category, price
FROM products
ORDER BY price DESC
LIMIT 5;

Challenge 5: Customers Who Signed Up in Q1 2024

Find customers who signed up between January 1 and March 31, 2024.

SELECT customer_id, first_name, last_name, city, signup_date
FROM customers
WHERE signup_date BETWEEN '2024-01-01' AND '2024-03-31'
ORDER BY signup_date;

Challenge 6: Unique Cities

List all unique cities where customers are located. Sort alphabetically.

SELECT DISTINCT city
FROM customers
ORDER BY city;

Challenge 7: Orders with High Value

Find all orders where total_amount exceeds Rs 50,000. Show order_id, customer_id, total_amount, and status.

SELECT order_id, customer_id, total_amount, status
FROM orders
WHERE total_amount > 50000
ORDER BY total_amount DESC;

Challenge 8: Product Search with LIKE

Find all products whose name contains "Pro" or "Premium".

SELECT product_id, product_name, category, price
FROM products
WHERE product_name LIKE '%Pro%'
   OR product_name LIKE '%Premium%';

Challenge 9: Orders NOT Completed

Find all orders that are NOT completed. Show order_id, status, and total_amount. Use IN operator.

SELECT order_id, status, total_amount
FROM orders
WHERE status IN ('pending', 'cancelled', 'returned')
ORDER BY status, total_amount DESC;

Challenge 10: Conditional Labels with CASE

Categorize products by price range. Under Rs 1000 = "Budget", Rs 1000 to Rs 10000 = "Mid-Range", above Rs 10000 = "Premium".

SELECT product_name, price,
  CASE
    WHEN price < 1000 THEN 'Budget'
    WHEN price BETWEEN 1000 AND 10000 THEN 'Mid-Range'
    ELSE 'Premium'
  END AS price_category
FROM products
ORDER BY price;