How to SELECT Data in SQL

-- Create sample table
CREATE TABLE products (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  price REAL,
  category TEXT,
  stock INTEGER
);

-- Insert data
INSERT INTO products VALUES 
  (1, 'Laptop', 999.99, 'Electronics', 50),
  (2, 'Mouse', 29.99, 'Electronics', 200),
  (3, 'Desk', 299.99, 'Furniture', 30),
  (4, 'Chair', 199.99, 'Furniture', 45),
  (5, 'Monitor', 449.99, 'Electronics', 75),
  (6, 'Keyboard', 79.99, 'Electronics', 150);

-- Basic SELECT
SELECT * FROM products;

-- SELECT specific columns with WHERE
SELECT name, price FROM products WHERE price > 100;

-- ORDER BY
SELECT name, price FROM products ORDER BY price DESC;