CRUD Operations

INSERT INTO users (name, email, age) 
VALUES ('John Doe', 'john@example.com', 25);

INSERT INTO users (name, email, age) VALUES
('Jane Smith', 'jane@example.com', 30),
('Bob Johnson', 'bob@example.com', 35),
('Alice Brown', 'alice@example.com', 28);

INSERT INTO users (name, email) 
VALUES ('Charlie Wilson', 'charlie@example.com');

-- Select all columns
SELECT * FROM users;

-- Select specific columns
SELECT name, email FROM users;

-- Basic condition
SELECT * FROM users WHERE age > 30;

-- Multiple conditions
SELECT * FROM users WHERE age > 25 AND name = 'John';

-- OR condition
SELECT * FROM users WHERE age < 25 OR age > 35;

-- Pattern matching
SELECT * FROM users WHERE name LIKE 'J%';  -- Starts with J
SELECT * FROM users WHERE email LIKE '%@example.com';  -- Ends with

-- Sort by age ascending
SELECT * FROM users ORDER BY age;

-- Sort by name descending
SELECT * FROM users ORDER BY name DESC;

-- Sort by multiple columns
SELECT * FROM users ORDER BY age DESC, name ASC;

-- Get first 5 users
SELECT * FROM users LIMIT 5;

-- Skip first 5, get next 5 (pagination)
SELECT * FROM users LIMIT 5 OFFSET 5;

UPDATE users 
SET age = 26 
WHERE name = 'John Doe';

UPDATE users 
SET age = 31, email = 'jane.smith@example.com' 
WHERE name = 'Jane Smith';

UPDATE users 
SET age = age + 1 
WHERE age < 30;

DELETE FROM users WHERE name = 'Bob Johnson';

DELETE FROM users WHERE age > 40;