Superstore Project

#This project utilizes the following Superstore data, and is aimed towards developing beginner skills.

CREATE TABLE superstore (
    item_id INTEGER PRIMARY KEY,
    item_name TEXT,
    category TEXT,
    price DECIMAL(10, 2),
    stock_quantity INTEGER,
    average_rating DECIMAL(3, 2)
);

INSERT INTO superstore (item_id, item_name, category, price, stock_quantity, average_rating)
VALUES
    (1, 'Stainless Steel Cookware Set', 'Kitchen Supplies', 89.99, 50, 4.6),
    (2, 'Memory Foam Mattress', 'Furnishings', 499.99, 30, 4.8),
    (3, 'Smart LED TV', 'Electronics', 549.00, 20, 4.5),
    (4, 'Robot Vacuum Cleaner', 'Appliances', 199.50, 40, 4.3),
    (5, 'Wireless Bluetooth Speaker', 'Electronics', 39.99, 60, 4.2),
    (6, 'Non-Stick Baking Set', 'Kitchen Supplies', 29.95, 80, 4.4),
    (7, 'Cotton Bedding Set', 'Furnishings', 89.00, 25, 4.7),
    (8, 'Smart Home Security Camera', 'Electronics', 79.95, 15, 4.1),
    (9, 'Air Purifier', 'Appliances', 129.50, 35, 4.6),
    (10, 'Premium Coffee Maker', 'Kitchen Supplies', 79.99, 50, 4.9),
    (11, 'Ergonomic Office Chair', 'Furnishings', 189.00, 20, 4.5),
    (12, 'Wireless Earbuds', 'Electronics', 49.99, 75, 4.3),
    (13, 'Slow Cooker', 'Appliances', 49.95, 30, 4.7),
    (14, 'Cutlery Set', 'Kitchen Supplies', 34.50, 40, 4.4),
    (15, 'Cozy Throw Blanket', 'Furnishings', 24.99, 100, 4.2);
    
    
-- © Copyright 2025 Break Into Tech  --


#For this project I used SQL to answer multiple prompts which you can find below along with my answers.

1. Write a SQL query that orders the items by price.
Answer:
SELECT item_name, price
FROM superstore
ORDER BY price;

2. Write your own SQL query that will show a statistic about the item prices, like a sum, average, minimum, maximum, or count.
Answer:
SELECT COUNT(price)
FROM superstore;

3. Write your own SQL query that will show a statistic about the price for items in the category of "Kitchen Supplies".
Answer:
SELECT SUM(price)
FROM superstore
WHERE category='Kitchen Supplies';

4. Come up with your own question about the data and try to answer it using SQL. For example: How many air purifiers are in stock?
Answer:
-- What is the name and price of items with an average rating greater than 4.5?
SELECT item_name, average_rating, price
FROM superstore
WHERE average_rating>4.5
ORDER BY average_rating DESC;