New
🚀 We just launched our new Chatbot: Erlang provides you with deeper analytics capabilities and can run code! 🚀

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

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

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.