Top SQL Queries for Practice (With Short Answers) - Real-Time Scenario Queries (81–100)

 

81. Find duplicate transactions
    Use GROUP BY transaction_id HAVING COUNT(*) > 1.
82. Find inactive customers
    Find customers with no orders in last 6 months.
83. Find repeat customers
    Group by customer and filter COUNT(order_id) > 1.
84. Find one-time customers
    Group by customer and filter COUNT(order_id) = 1.
85. Find top-selling products
    Group by product and order by total quantity sold desc.
86. Find least-selling products
    Group by product and order by total quantity sold asc.
87. Find average order value
    SUM(order_amount) / COUNT(order_id).
88. Find monthly revenue
    Group by month and sum order amount.
89. Find YoY sales growth
    Compare current year sales with previous year sales.
90. Find MoM sales growth
    Use LAG() on monthly sales.
91. Find customer lifetime value
    Sum total purchase amount by customer.
92. Find customer churn
    Find customers with no recent activity.
93. Find best performing region
    Group by region and sort by sales desc.
94. Find worst performing region
    Group by region and sort by sales asc.
95. Find null-heavy columns
    Use COUNT(*) - COUNT(column).
96. Find bad quality records
    Check NULLs, duplicates, invalid formats.
97. Find orphan records
    Use LEFT JOIN and filter unmatched child records.
98. Validate source vs target count
    Compare COUNT(*) from both tables.
99. Find changed records in ETL
    Compare source and target using hash/timestamp.
100. Find load failures in ETL
     Check audit table, rejected rows, and error logs.

Top SQL Queries for Practice (With Short Answers) - Basic Select Queries (1–15)

 

1. Fetch all records from Employee table

    SELECT * FROM Employee;

2. Fetch only employee names

    SELECT emp_name FROM Employee;

3. Fetch unique department names

    SELECT DISTINCT department FROM Employee;

4. Fetch employees with salary > 50000

    SELECT * FROM Employee WHERE salary > 50000;

5. Fetch employees from HR department

    SELECT * FROM Employee WHERE department = 'HR';

6. Fetch employees with salary between 30000 and 60000

    SELECT * FROM Employee WHERE salary BETWEEN 30000 AND 60000;

7. Fetch employees in HR or IT

    SELECT * FROM Employee WHERE department IN ('HR','IT');

8. Fetch employees whose name starts with A

    SELECT * FROM Employee WHERE emp_name LIKE 'A%';

9. Fetch employees whose name ends with n

    SELECT * FROM Employee WHERE emp_name LIKE '%n';

10. Fetch employees whose name contains 'ar'

    SELECT * FROM Employee WHERE emp_name LIKE '%ar%';

11. Fetch employees with NULL manager_id

    SELECT * FROM Employee WHERE manager_id IS NULL;

12. Fetch employees sorted by salary ascending

    SELECT * FROM Employee ORDER BY salary ASC;

13. Fetch employees sorted by salary descending

    SELECT * FROM Employee ORDER BY salary DESC;

14. Fetch top 5 highest paid employees

    SELECT TOP 5 * FROM Employee ORDER BY salary DESC;

15. Fetch first 5 rows (MySQL)

    SELECT * FROM Employee LIMIT 5;