SQL Queries-SQL Query Crafting Tool

Example

SELECT name, age FROM users WHERE age > 18;

Scenario

Used in applications to list all users above 18 years of age, such as filtering eligible participants for a service that has age restrictions.

Example

INSERT INTO orders (customer_id, order_date, status) VALUES (123, '2023-04-01', 'Pending');

Scenario

E-commerce platforms use this function to add a new order record when a customer places an order.

Example

UPDATE employees SET salary = salary * 1.05 WHERE department = 'Engineering';

Scenario

Companies may increase salaries by 5% for all employees in the Engineering department as part of an annual raise.

Example

DELETE FROM temporary_logs WHERE created_at < '2023-01-01';

Scenario

To maintain performance and storage efficiency, applications periodically remove outdated logs or temporary data that's no longer needed.

Example

SELECT AVG(salary) FROM employees WHERE department = 'Sales';

Scenario

Business analysts might use such queries to evaluate the average salary in the Sales department, aiding in budget planning and salary adjustments.