New
We're launching new features soon! 🚀 New Datasources, Connectors and Visualizations in May.

Your virtual data analyst.

Leverage your data potential with AI-powered analytics. Get quick insights, build dashboards, generate reports, and ultimately make better-informed decisions for your business.

You
How many engineers with clearance for engine type C do we have and where are they located?
SELECT location, 
COUNT(id) AS
number of engineers 
FROM engineers 
WHERE 
FIND_IN_SET('C',
clearance) ` >` 0 
GROUP BY location;
locationengineers
UK12
Germany36
Netherlands8
Turbular
There are 23 free engineers for engine type C located in the Germany, 12 in the UK and 8 in the Netherlands.
Turbular
There are 23 free engineers with clearance for engine type C.
Partnered with:
Microsoft for Startups
Connect to your
Tap into your data instantly with our SaaS platform 🌐 - noSQL knowledge required! Just ask your question and receive immediate answers.
Elevate your e-commerce 🛍️ strategy by centralizing all your tools in one hub for in-depth Customer Lifetime Value analysis and more.
file_type_mongo
Easy to integrate with

A fully integrated Data Analytics solution for all your needs

Easily upload or register all your different data sources ranging from databases to Excel files directly in the application and get insights in seconds. No need to waste valuable time anymore looking through data entries.
Get insights quickly

Chat with your data and easily gain insights through natural language

Do not waste valuable time anymore trying to extract insights from your data. Simply ask our AI Data Analyst and it will provide you with visualizations, data exports, and answers to your most pressing data questions.

 

Build beautiful visualizations
Create stunning visualizations with
our easy to use drag and drop interface.

Your data, your way.

Connecting to BigQuery

Learn how to connect to BigQuery and start analyzing your data in minutes. We provide a step-by-step guide on how to connect to BigQuery and how to use it with our AI Data Analyst.

Read Article

Connecting to Databases

An easy to follow guide on how to connect to databases to be able to jumpstart your data analysis. We provide a step-by-step guide on how to connect to databases and how to use it with our AI Data Analyst.

Read Article

INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT DISTINCT category FROM products; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM employees WHERE age < 25; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM departments WHERE manager_id = 567; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM purchases WHERE quantity > 1; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM users WHERE age > 18; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM purchases WHERE product_id = 456; DELETE FROM tasks WHERE status = 'completed'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM purchases WHERE quantity > 1; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM purchases WHERE product_id = 456; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM tasks WHERE due_date < CURDATE(); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM messages WHERE receiver_id = 456; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM comments WHERE post_id = 234; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM messages WHERE sender_id = 123; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM employees WHERE age < 25; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM tasks WHERE due_date < CURDATE(); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM departments WHERE manager_id = 567; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM transactions WHERE amount < 0; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM users WHERE age > 18; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM transactions WHERE amount < 0; DELETE FROM employees WHERE age < 25; DELETE FROM departments WHERE manager_id = 567; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM comments WHERE post_id = 234; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM messages WHERE sender_id = 123; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM users WHERE age > 18; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM users WHERE last_login < '2024-01-01'; SELECT DISTINCT category FROM products; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT DISTINCT category FROM products; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM transactions WHERE amount < 0; DELETE FROM comments WHERE post_id = 234; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM departments WHERE manager_id = 567; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM employees WHERE age < 25; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT DISTINCT category FROM products; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM comments WHERE post_id = 234; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM purchases WHERE product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM transactions WHERE amount < 0; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM users WHERE age > 18; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM comments WHERE post_id = 234; SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM purchases WHERE quantity > 1; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM transactions WHERE amount < 0; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM departments WHERE manager_id = 567; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM customers WHERE country <> 'USA'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM departments WHERE manager_id = 567; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM messages WHERE receiver_id = 456; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM users WHERE age > 18; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM reviews WHERE rating < 3; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM users WHERE age > 18; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM users WHERE age > 18; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM messages WHERE sender_id = 123; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM users WHERE age > 18; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM transactions WHERE amount < 0; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM employees WHERE age < 25; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM purchases WHERE product_id = 456; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM messages WHERE receiver_id = 456; DELETE FROM messages WHERE sender_id = 123; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM messages WHERE receiver_id = 456; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM purchases WHERE quantity > 1; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM messages WHERE sender_id = 123; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM reviews WHERE rating < 3; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM employees WHERE age < 25; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM employees WHERE age < 25; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT DISTINCT category FROM products; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT DISTINCT category FROM products; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM tasks WHERE status = 'completed'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM comments WHERE post_id = 234; DELETE FROM tasks WHERE status = 'completed'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM departments WHERE manager_id = 567; DELETE FROM comments WHERE post_id = 234; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM tasks WHERE status = 'completed'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM users WHERE age > 18; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM tasks WHERE status = 'completed'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM employees WHERE age < 25; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM comments WHERE post_id = 234; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM comments WHERE post_id = 234; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM users WHERE age > 18; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM comments WHERE post_id = 234; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM purchases WHERE quantity > 1; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM employees WHERE age < 25; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM departments WHERE manager_id = 567; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM comments WHERE post_id = 234; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM transactions WHERE amount < 0; DELETE FROM transactions WHERE amount < 0; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM customers WHERE country <> 'USA'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT name, email FROM customers WHERE country = 'USA'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM users WHERE age > 18; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM customers WHERE country <> 'USA'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE inventory SET quantity = 0 WHERE quantity < 0; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM employees WHERE age < 25; DELETE FROM reviews WHERE rating < 3; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM tasks WHERE status = 'completed'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT DISTINCT category FROM products; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM messages WHERE sender_id = 123; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM users WHERE age > 18; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM departments WHERE manager_id = 567; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM purchases WHERE product_id = 456; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM transactions WHERE amount < 0; DELETE FROM comments WHERE post_id = 234; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM reviews WHERE rating < 3; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM messages WHERE sender_id = 123; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM purchases WHERE product_id = 456; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM comments WHERE post_id = 234; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM employees WHERE age < 25; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE inventory SET quantity = 0 WHERE quantity < 0; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM messages WHERE sender_id = 123; DELETE FROM comments WHERE post_id = 234; SELECT DISTINCT category FROM products; UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM employees WHERE age < 25; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM users WHERE age > 18; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM purchases WHERE product_id = 456; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM reviews WHERE rating < 3; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM transactions WHERE amount < 0; UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM transactions WHERE amount < 0; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM messages WHERE sender_id = 123; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM comments WHERE post_id = 234; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM users WHERE age > 18; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT DISTINCT category FROM products; DELETE FROM reviews WHERE rating < 3; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM purchases WHERE quantity > 1; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM transactions WHERE amount < 0; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM departments WHERE manager_id = 567; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM tasks WHERE status = 'completed'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM comments WHERE post_id = 234; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM comments WHERE post_id = 234; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM transactions WHERE amount < 0; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM employees WHERE age < 25; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM purchases WHERE product_id = 456; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM users WHERE age > 18; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM purchases WHERE quantity > 1; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM comments WHERE post_id = 234; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM employees WHERE age < 25; DELETE FROM employees WHERE age < 25; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM comments WHERE post_id = 234; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM transactions WHERE amount < 0; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM reviews WHERE rating < 3; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM employees WHERE age < 25; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM departments WHERE manager_id = 567; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM users WHERE age > 18; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM customers WHERE country <> 'USA'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM reviews WHERE rating < 3; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM reviews WHERE rating < 3; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM purchases WHERE product_id = 456; DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; DELETE FROM transactions WHERE amount < 0; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM messages WHERE receiver_id = 456; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM reviews WHERE rating < 3; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM purchases WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM purchases WHERE quantity > 1; SELECT DISTINCT category FROM products; DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM messages WHERE sender_id = 123; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT DISTINCT category FROM products; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM users WHERE age > 18; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM users WHERE age > 18; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT DISTINCT category FROM products; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM employees WHERE age < 25; DELETE FROM purchases WHERE product_id = 456; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM users WHERE age > 18; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM messages WHERE sender_id = 123; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM messages WHERE sender_id = 123; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT name, email FROM customers WHERE country = 'USA'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM messages WHERE receiver_id = 456; DELETE FROM transactions WHERE amount < 0; DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM employees WHERE age < 25; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT DISTINCT category FROM products; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM reviews WHERE rating < 3; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM users WHERE age > 18; DELETE FROM purchases WHERE product_id = 456; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM users WHERE age > 18; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM tasks WHERE status = 'completed'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM purchases WHERE quantity > 1; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM purchases WHERE product_id = 456; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM purchases WHERE product_id = 456; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM users WHERE age > 18; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM users WHERE age > 18; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM users WHERE age > 18; DELETE FROM reviews WHERE rating < 3; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT DISTINCT category FROM products; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM employees WHERE age < 25; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM departments WHERE manager_id = 567; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM customers WHERE country <> 'USA'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM tasks WHERE status = 'completed'; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM employees WHERE age < 25; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM users WHERE age > 18; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM messages WHERE receiver_id = 456; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM reviews WHERE rating < 3; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM transactions WHERE amount < 0; DELETE FROM departments WHERE manager_id = 567; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM employees WHERE age < 25; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM users WHERE age > 18; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT DISTINCT category FROM products; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM employees WHERE age < 25; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM transactions WHERE amount < 0; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM employees WHERE age < 25; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM comments WHERE post_id = 234; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM transactions WHERE amount < 0; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM purchases WHERE quantity > 1; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM reviews WHERE rating < 3; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM messages WHERE receiver_id = 456; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM messages WHERE receiver_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT DISTINCT category FROM products; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT DISTINCT category FROM products; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM tasks WHERE status = 'completed'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM transactions WHERE amount < 0; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM messages WHERE sender_id = 123; DELETE FROM purchases WHERE product_id = 456; SELECT DISTINCT category FROM products; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM purchases WHERE quantity > 1; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM transactions WHERE amount < 0; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM users WHERE age > 18; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM comments WHERE post_id = 234; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM purchases WHERE product_id = 456; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM employees WHERE age < 25; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM reviews WHERE rating < 3; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM employees WHERE age < 25; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT name, email FROM customers WHERE country = 'USA'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM purchases WHERE quantity > 1; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM purchases WHERE product_id = 456; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT name, email FROM customers WHERE country = 'USA'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM messages WHERE receiver_id = 456; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM users WHERE age > 18; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT DISTINCT category FROM products; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM tasks WHERE status = 'completed'; SELECT DISTINCT category FROM products; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM comments WHERE post_id = 234; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM purchases WHERE product_id = 456; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM messages WHERE receiver_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM products WHERE name LIKE '%phone%'; SELECT DISTINCT category FROM products; DELETE FROM reviews WHERE rating < 3; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM purchases WHERE quantity > 1; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM reviews WHERE rating < 3; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM users WHERE age > 18; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM purchases WHERE product_id = 456; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT name, email FROM customers WHERE country = 'USA'; SELECT DISTINCT category FROM products; DELETE FROM messages WHERE sender_id = 123; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT name, email FROM customers WHERE country = 'USA'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM employees WHERE age < 25; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM reviews WHERE rating < 3; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM users WHERE age > 18; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM purchases WHERE quantity > 1; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM transactions WHERE amount < 0; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM departments WHERE manager_id = 567; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM purchases WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM purchases WHERE product_id = 456; DELETE FROM transactions WHERE amount < 0; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM reviews WHERE rating < 3; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM employees WHERE age < 25; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM products WHERE price BETWEEN 100 AND 200; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM departments WHERE manager_id = 567; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT name, email FROM customers WHERE country = 'USA'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT DISTINCT category FROM products; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM departments WHERE manager_id = 567; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM employees WHERE age < 25; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM tasks WHERE status = 'completed'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM reviews WHERE rating < 3; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM purchases WHERE quantity > 1; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM users WHERE age > 18; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM purchases WHERE product_id = 456; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT DISTINCT category FROM products; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM users WHERE age > 18; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM departments WHERE manager_id = 567; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM departments WHERE manager_id = 567; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM messages WHERE sender_id = 123; DELETE FROM departments WHERE manager_id = 567; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM departments WHERE manager_id = 567; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM employees WHERE age < 25; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM purchases WHERE quantity > 1; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM comments WHERE post_id = 234; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM purchases WHERE product_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM reviews WHERE rating < 3; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM messages WHERE sender_id = 123; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM users WHERE age > 18; DELETE FROM reviews WHERE rating < 3; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM comments WHERE post_id = 234; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM users WHERE age > 18; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM employees WHERE age < 25; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM transactions WHERE amount < 0; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM departments WHERE manager_id = 567; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM employees WHERE age < 25; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM purchases WHERE product_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM purchases WHERE product_id = 456; SELECT DISTINCT category FROM products; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM departments WHERE manager_id = 567; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM comments WHERE post_id = 234; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM reviews WHERE rating < 3; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM comments WHERE post_id = 234; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM employees WHERE age < 25; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM users WHERE last_login < '2024-01-01'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM messages WHERE sender_id = 123; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM employees WHERE age < 25; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM reviews WHERE rating < 3; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT DISTINCT category FROM products; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM users WHERE age > 18; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM purchases WHERE quantity > 1; DELETE FROM reviews WHERE rating < 3; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM employees WHERE age < 25; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM users WHERE age > 18; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM employees WHERE age < 25; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM tasks WHERE status = 'completed'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT DISTINCT category FROM products; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM users WHERE age > 18; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM customers WHERE country <> 'USA'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM employees WHERE age < 25; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM transactions WHERE amount < 0; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM purchases WHERE product_id = 456; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM purchases WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM reviews WHERE rating < 3; DELETE FROM tasks WHERE status = 'completed'; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM comments WHERE post_id = 234; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM departments WHERE manager_id = 567; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM employees WHERE age < 25; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM purchases WHERE product_id = 456; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM purchases WHERE product_id = 456; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM transactions WHERE amount < 0; DELETE FROM departments WHERE manager_id = 567; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM messages WHERE sender_id = 123; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM purchases WHERE quantity > 1; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM purchases WHERE quantity > 1; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT DISTINCT category FROM products; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT DISTINCT category FROM products; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); DELETE FROM employees WHERE age < 25; DELETE FROM employees WHERE age < 25; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM departments WHERE manager_id = 567; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM purchases WHERE quantity > 1; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT DISTINCT category FROM products; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT DISTINCT category FROM products; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM transactions WHERE amount < 0; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM transactions WHERE amount < 0; DELETE FROM messages WHERE receiver_id = 456; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM tasks WHERE status = 'completed'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT DISTINCT category FROM products; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM messages WHERE sender_id = 123; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM messages WHERE receiver_id = 456; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT DISTINCT category FROM products; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM users WHERE age > 18; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT DISTINCT category FROM products; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM purchases WHERE quantity > 1; DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE name LIKE '%phone%'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT DISTINCT category FROM products; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM purchases WHERE product_id = 456; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM purchases WHERE product_id = 456; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM purchases WHERE product_id = 456; DELETE FROM messages WHERE sender_id = 123; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM purchases WHERE product_id = 456; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM products WHERE name LIKE '%phone%'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM reviews WHERE rating < 3; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM reviews WHERE rating < 3; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM messages WHERE receiver_id = 456; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM purchases WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM purchases WHERE quantity > 1; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM reviews WHERE rating < 3; SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM messages WHERE sender_id = 123; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM reviews WHERE rating < 3; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM users WHERE age > 18; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM reviews WHERE rating < 3; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM messages WHERE sender_id = 123; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM reviews WHERE rating < 3; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM purchases WHERE quantity > 1; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM messages WHERE receiver_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM comments WHERE post_id = 234; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM purchases WHERE quantity > 1; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM messages WHERE receiver_id = 456; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM transactions WHERE amount < 0; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM employees WHERE age < 25; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM purchases WHERE product_id = 456; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM purchases WHERE product_id = 456; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM messages WHERE sender_id = 123; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM comments WHERE post_id = 234; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM tasks WHERE status = 'completed'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM transactions WHERE amount < 0; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM reviews WHERE rating < 3; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM employees WHERE age < 25; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM transactions WHERE amount < 0; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM employees WHERE age < 25; DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM users WHERE age > 18; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM comments WHERE post_id = 234; DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT DISTINCT category FROM products; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM departments WHERE manager_id = 567; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM reviews WHERE rating < 3; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM messages WHERE sender_id = 123; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM messages WHERE sender_id = 123; DELETE FROM purchases WHERE product_id = 456; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM reviews WHERE rating < 3; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM purchases WHERE quantity > 1; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM comments WHERE post_id = 234; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM users WHERE age > 18; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM reviews WHERE rating < 3; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM transactions WHERE amount < 0; DELETE FROM departments WHERE manager_id = 567; DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM comments WHERE post_id = 234; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM purchases WHERE product_id = 456; SELECT * FROM purchases WHERE quantity > 1; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM products WHERE name LIKE '%phone%'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM reviews WHERE rating < 3; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM employees WHERE age < 25; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM departments WHERE manager_id = 567; DELETE FROM employees WHERE age < 25; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM users WHERE age > 18; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM departments WHERE manager_id = 567; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM messages WHERE receiver_id = 456; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM employees WHERE age < 25; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM customers WHERE country <> 'USA'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM departments WHERE manager_id = 567; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM messages WHERE sender_id = 123; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM reviews WHERE rating < 3; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM departments WHERE manager_id = 567; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT DISTINCT category FROM products; SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM reviews WHERE rating < 3; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM transactions WHERE amount < 0; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM users WHERE age > 18; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM departments WHERE manager_id = 567; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM reviews WHERE rating < 3; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM reviews WHERE rating < 3; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE users SET last_login = NOW() WHERE username = 'user123'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM departments WHERE manager_id = 567; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM comments WHERE post_id = 234; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM comments WHERE post_id = 234; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM customers WHERE country <> 'USA'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM messages WHERE sender_id = 123; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM departments WHERE manager_id = 567; DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM reviews WHERE rating < 3; DELETE FROM reviews WHERE rating < 3; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT name, email FROM customers WHERE country = 'USA'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM purchases WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM purchases WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM purchases WHERE product_id = 456; SELECT * FROM purchases WHERE quantity > 1; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM purchases WHERE product_id = 456; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM reviews WHERE rating < 3; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM comments WHERE post_id = 234; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM departments WHERE manager_id = 567; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM users WHERE age > 18; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM messages WHERE sender_id = 123; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM tasks WHERE status = 'completed'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM employees WHERE age < 25; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM reviews WHERE rating < 3; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM comments WHERE post_id = 234; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM comments WHERE post_id = 234; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM messages WHERE sender_id = 123; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM transactions WHERE amount < 0; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM tasks WHERE status = 'completed'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM comments WHERE post_id = 234; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM reviews WHERE rating < 3; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT category, COUNT(*) FROM products GROUP BY category; SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM tasks WHERE status = 'completed'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM employees WHERE age < 25; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM users WHERE age > 18; DELETE FROM transactions WHERE amount < 0; DELETE FROM messages WHERE sender_id = 123; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM departments WHERE manager_id = 567; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT DISTINCT category FROM products; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM messages WHERE sender_id = 123; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM users WHERE age > 18; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM transactions WHERE amount < 0; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM users WHERE age > 18; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM comments WHERE post_id = 234; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT name, email FROM customers WHERE country = 'USA'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT DISTINCT category FROM products; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT DISTINCT category FROM products; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM reviews WHERE rating < 3; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM users WHERE age > 18; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM comments WHERE post_id = 234; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); DELETE FROM tasks WHERE status = 'completed'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM purchases WHERE product_id = 456; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM comments WHERE post_id = 234; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM comments WHERE post_id = 234; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; DELETE FROM departments WHERE manager_id = 567; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM messages WHERE sender_id = 123; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM tasks WHERE due_date < CURDATE(); SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; DELETE FROM reviews WHERE rating < 3; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM transactions WHERE amount < 0; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM departments WHERE manager_id = 567; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM users WHERE age > 18; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM purchases WHERE quantity > 1; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < '2024-02-28'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM reviews WHERE rating < 3; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT DISTINCT category FROM products; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM messages WHERE sender_id = 123; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM reviews WHERE rating < 3; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM transactions WHERE amount < 0; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM products WHERE category = 'Clothing' AND price < 50INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM messages WHERE sender_id = 123; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM employees WHERE age < 25; SELECT * FROM users WHERE age > 18; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT DISTINCT category FROM products; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM employees WHERE age < 25; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM employees WHERE age < 25; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = 100 WHERE product_id = 789; DELETE FROM departments WHERE manager_id = 567; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM comments WHERE post_id = 234; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM reviews WHERE rating < 3; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM comments WHERE post_id = 234; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; DELETE FROM departments WHERE manager_id = 567; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM users WHERE last_login < '2024-01-01'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM purchases WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM reviews WHERE rating < 3; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); DELETE FROM transactions WHERE amount < 0; DELETE FROM comments WHERE post_id = 234; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM purchases WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM users WHERE age > 18; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM users WHERE age > 18; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM tasks WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; SELECT name, email FROM customers WHERE country = 'USA'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM messages WHERE receiver_id = 456; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM employees WHERE department = 'IT' AND age > 40; DELETE FROM purchases WHERE product_id = 456; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM messages WHERE sender_id = 123; DELETE FROM departments WHERE manager_id = 567; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM departments WHERE manager_id = 567; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); DELETE FROM purchases WHERE product_id = 456; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM users WHERE age > 18; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM transactions WHERE amount < 0; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM transactions WHERE amount < 0; UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT DISTINCT category FROM products; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM customers WHERE country <> 'USA'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM comments WHERE post_id = 234; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM tasks WHERE status = 'completed'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM customers WHERE country IN ('USA', 'Canada'); SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM messages WHERE sender_id = 123; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM reviews WHERE rating < 3; DELETE FROM employees WHERE age < 25; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM tasks WHERE due_date < '2024-02-28'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM purchases WHERE product_id = 456; SELECT * FROM users WHERE age > 18; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < CURDATE(); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM products WHERE name LIKE '%phone%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM customers WHERE country <> 'USA'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; DELETE FROM departments WHERE manager_id = 567; DELETE FROM reviews WHERE rating < 3; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM messages WHERE sender_id = 123; DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM employees WHERE name LIKE 'J%'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT name, email FROM customers WHERE country = 'USA'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE orders SET status = 'shipped' WHERE status = 'pending'; SELECT * FROM employees WHERE name LIKE 'J%'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM users WHERE age > 18; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM messages WHERE sender_id = 123; SELECT DISTINCT category FROM products; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT DISTINCT category FROM products; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM transactions WHERE amount < 0; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM purchases WHERE quantity > 1; DELETE FROM transactions WHERE amount < 0; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM users WHERE age > 18; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT DISTINCT category FROM products; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM transactions WHERE amount < 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM messages WHERE receiver_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE users SET password = 'newpass' WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM employees WHERE name LIKE 'J%'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT product_id, MAX(price) FROM products GROUP BY product_id; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM users WHERE age > 18; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT AVG(price) FROM products WHERE category = 'Electronics'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM purchases WHERE product_id = 456; DELETE FROM messages WHERE sender_id = 123; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; DELETE FROM tasks WHERE status = 'completed'; DELETE FROM reviews WHERE rating < 3; DELETE FROM comments WHERE post_id = 234; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM customers WHERE country IN ('USA', 'Canada'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT DISTINCT category FROM products; UPDATE users SET last_login = NOW() WHERE username = 'user123'; SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM purchases WHERE quantity > 1; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); DELETE FROM purchases WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO users (username, password) VALUES ('user123', 'pass456'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM tasks WHERE status = 'completed'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM transactions WHERE amount < 0; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; UPDATE inventory SET quantity = 0 WHERE quantity < 0; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; DELETE FROM reviews WHERE rating < 3; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; DELETE FROM purchases WHERE product_id = 456; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); SELECT category, COUNT(*) FROM products GROUP BY category; DELETE FROM messages WHERE receiver_id = 456; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM transactions WHERE amount < 0; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM transactions WHERE amount < 0; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); DELETE FROM reviews WHERE rating < 3; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM users WHERE last_login < '2024-01-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM employees WHERE department LIKE '%Eng%'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT DISTINCT category FROM products; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM tasks WHERE status = 'completed'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM transactions WHERE amount < 0; SELECT * FROM transactions WHERE DATE(transaction_date) = CURDATE(); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM employees WHERE age < 25; DELETE FROM messages WHERE receiver_id = 456; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT AVG(price) FROM products WHERE category = 'Electronics'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); UPDATE inventory SET quantity = quantity + 20 WHERE product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM purchases WHERE product_id = 456; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE users SET last_login = NOW() WHERE username = 'user123'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM departments WHERE manager_id = 567; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); DELETE FROM comments WHERE post_id = 234; SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT category, COUNT(*) FROM products GROUP BY category; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM messages WHERE sender_id = 123; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM employees WHERE age < 25; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM departments WHERE manager_id = 567; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM reviews WHERE product_id = 123 AND rating < 2; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; DELETE FROM tasks WHERE due_date < CURDATE(); DELETE FROM tasks WHERE status = 'completed'; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); UPDATE inventory SET quantity = 0 WHERE quantity < 0; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM transactions WHERE amount < 0; DELETE FROM reviews WHERE product_id = 123 AND rating < 2; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); DELETE FROM messages WHERE sender_id = 123; DELETE FROM transactions WHERE amount < 0; SELECT * FROM employees WHERE department LIKE 'Sales%'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM products WHERE price BETWEEN 100 AND 200; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM products WHERE price BETWEEN 100 AND 200; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); DELETE FROM tasks WHERE status = 'completed'; DELETE FROM tasks WHERE status = 'completed'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM employees WHERE department LIKE 'Sales%'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE inventory SET quantity = 100 WHERE product_id = 789; SELECT * FROM employees WHERE department LIKE 'Sales%'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM messages WHERE receiver_id = 456; DELETE FROM comments WHERE post_id = 234; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; DELETE FROM transactions WHERE amount < 0; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM purchases WHERE quantity > 1; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; DELETE FROM employees WHERE age < 25; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; UPDATE users SET last_login = NOW() WHERE username = 'user123'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM users WHERE age > 18; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM employees WHERE department = 'IT' AND age > 40; SELECT category, COUNT(*) FROM products GROUP BY category; INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (789, 123, 3, '2024-02-15'); INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM employees WHERE department LIKE '%Eng%'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); DELETE FROM messages WHERE sender_id = 123; UPDATE users SET password = 'newpass' WHERE username = 'user123'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); DELETE FROM reviews WHERE rating < 3; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM reviews WHERE rating < 3; UPDATE users SET password = 'newpass' WHERE username = 'user123'; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; UPDATE tasks SET priority = 'high' WHERE due_date < '2024-02-28' AND status = 'pending'; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM tasks WHERE due_date < CURDATE(); SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; UPDATE inventory SET quantity = 100 WHERE product_id = 789; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT name, email FROM customers WHERE country = 'USA'; INSERT INTO departments (name, manager_id) VALUES ('Marketing', 567); INSERT INTO tasks (description, due_date, status) VALUES ('Meeting with client', '2024-03-15', 'pending'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; UPDATE inventory SET quantity = 0 WHERE quantity < 0; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; DELETE FROM tasks WHERE status = 'completed'; UPDATE users SET password = 'newpass' WHERE username = 'user123'; UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; UPDATE users SET status = 'inactive' WHERE last_activity < '2023-12-01'; DELETE FROM comments WHERE post_id = 234; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT * FROM orders WHERE DATE(order_date) = '2024-02-28'; SELECT * FROM employees WHERE department LIKE '%Eng%'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; INSERT INTO products (name, price, category) VALUES ('Smartphone', 599, 'Electronics'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; INSERT INTO users (username, password) VALUES ('user123', 'pass456'); DELETE FROM messages WHERE sender_id = 123; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM comments WHERE post_id = 234; INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); SELECT * FROM employees WHERE name LIKE 'J%'; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT name, email FROM customers WHERE country = 'USA'; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; SELECT * FROM products WHERE name LIKE '%phone%'; DELETE FROM messages WHERE receiver_id = 456; INSERT INTO products (name, price, category) VALUES ('Headphones', 49, 'Electronics'); SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM products WHERE category = 'Clothing' AND price < 50DELETE FROM departments WHERE manager_id = 567; DELETE FROM reviews WHERE rating < 3; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); INSERT INTO orders (customer_id, product_id, quantity, order_date) VALUES (456, 789, 2, '2024-02-10'); DELETE FROM users WHERE last_login < '2024-01-01'; DELETE FROM tasks WHERE due_date < CURDATE(); INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); SELECT * FROM purchases WHERE quantity > 1; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT product_id, MAX(price) FROM products GROUP BY product_id; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT * FROM purchases WHERE quantity > 1; DELETE FROM purchases WHERE product_id = 456; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO employees (name, age, department) VALUES ('Michael', 35, 'Finance'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); DELETE FROM employees WHERE department = 'IT' AND age > 40; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT * FROM products WHERE category IN ('Clothing', 'Shoes'); INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM transactions WHERE amount < 0; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); SELECT COUNT(*) FROM customers WHERE country = 'Germany'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; INSERT INTO employees (name, age, department) VALUES ('Sarah', 40, 'HR'); SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM reviews WHERE rating < 3; DELETE FROM purchases WHERE product_id = 456; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; SELECT * FROM users WHERE age > 18; SELECT * FROM orders WHERE DATE(order_date) BETWEEN '2024-01-01' AND '2024-01-31'; DELETE FROM purchases WHERE product_id = 456; SELECT DISTINCT category FROM products; SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM users WHERE age > 18; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); SELECT * FROM employees WHERE age BETWEEN 25 AND 35; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE orders SET status = 'cancelled' WHERE customer_id = 789 AND order_date < '2024-02-01'; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM customers WHERE email LIKE '%@gmail.com'; DELETE FROM employees WHERE age < 25; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM comments WHERE post_id = 234; SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products); SELECT AVG(price) FROM products WHERE category = 'Electronics'; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); DELETE FROM tasks WHERE due_date < '2024-02-28'; DELETE FROM employees WHERE age < 25; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); SELECT * FROM products WHERE name LIKE '%phone%'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT'); DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; SELECT * FROM orders ORDER BY order_date DESC LIMIT 10; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; DELETE FROM orders WHERE customer_id = 456 AND status = 'cancelled'; DELETE FROM purchases WHERE customer_id = 123 AND product_id = 456; SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; SELECT * FROM employees WHERE department LIKE '%Eng%'; SELECT * FROM customers WHERE country <> 'USA'; DELETE FROM employees WHERE age < 25; SELECT AVG(salary) FROM employees WHERE department = 'Finance'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; INSERT INTO messages (sender_id, receiver_id, message) VALUES (456, 789, 'How are you?'); INSERT INTO employees (name, age, department) VALUES ('Emily', 28, 'Marketing'); UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 456; SELECT AVG(price) FROM products WHERE category = 'Electronics'; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; DELETE FROM purchases WHERE product_id = 456; SELECT * FROM products WHERE category = 'Electronics' ORDER BY price ASC; SELECT name, email FROM customers WHERE country = 'USA'; DELETE FROM reviews WHERE rating < 3; SELECT * FROM users WHERE age > 18; DELETE FROM employees WHERE department = 'IT' AND age > 40; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; UPDATE employees SET manager_id = 789 WHERE department = 'HR'; DELETE FROM comments WHERE post_id = 234; INSERT INTO users (username, password, email) VALUES ('newuser', 'newpass', 'newuser@example.com'); INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; SELECT * FROM products WHERE category = 'Clothing' AND price < 50UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT DISTINCT category FROM products; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM tasks WHERE status = 'pending' ORDER BY due_date ASC LIMIT 10; UPDATE inventory SET quantity = quantity + 10 WHERE product_id = 123; SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM employees WHERE department LIKE 'Sales%'; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT * FROM customers WHERE country <> 'USA'; INSERT INTO customers (name, email, country) VALUES ('Alice', 'alice@example.com', 'Canada'); SELECT * FROM orders WHERE status IN ('shipped', 'delivered'); SELECT product_id, MAX(price) FROM products GROUP BY product_id; SELECT * FROM orders WHERE customer_id = 789 AND status = 'delivered'; SELECT DISTINCT category FROM products; SELECT * FROM employees ORDER BY salary DESC LIMIT 5; SELECT * FROM employees WHERE age BETWEEN 25 AND 35; DELETE FROM users WHERE last_login < '2024-01-01'; SELECT DISTINCT category FROM products; INSERT INTO reviews (product_id, customer_id, rating, comment) VALUES (123, 789, 4, 'Great product!'); UPDATE users SET email = 'newemail@example.com' WHERE username = 'user123'; INSERT INTO purchases (customer_id, product_id, quantity) VALUES (123, 456, 2); SELECT * FROM orders WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01'; UPDATE inventory SET quantity = quantity - 1 WHERE product_id = 123 AND quantity > 0; SELECT * FROM products WHERE category = 'Clothing' AND price < 50SELECT name, email FROM customers WHERE country = 'USA'; SELECT category, COUNT(*) FROM products GROUP BY category; SELECT * FROM transactions WHERE amount > 1000 AND status = 'approved'; SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id; INSERT INTO messages (sender_id, receiver_id, message) VALUES (123, 456, 'Hello there!'); SELECT name, email FROM customers WHERE country = 'USA'; SELECT * FROM products WHERE price > 500 AND category = 'Electronics'; UPDATE tasks SET status = 'completed' WHERE due_date < '2024-02-28'; SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id; DELETE FROM reviews WHERE rating < 3;

Ready? Let's get started!

Discover how easy Data Analytics can be and focus your time on making more meaningful decisions. Does our offer not fit your needs? Our sales team will be happy to advise you and create a customized offer tailored to your company.