Amazon Data Analyst Interview Questions

SQL Questions

1. Write a query to fetch the top 5 customers with the highest purchase amounts from a Sales table.

2. How would you identify and count duplicate orders in a table based on multiple columns, such as customer_id and order_date?
3. Write a query to retrieve employee details along with their respective department names and manager names using joins on the Employees and Departments tables.
4. Write a query to calculate the total revenue generated by each product category from an Orders table.
5. Write a query to find the days between the order_date and delivery_date for all completed orders.
6. Write a query to find all products whose total sales quantity exceeds 1,000 units, grouped by product ID.
7. Write a query to retrieve all rows where the email column is NULL in a Customer table.
8. Write a query to find gaps in a sequence of numbers in a table.
9. Write a query to find the maximum difference between two consecutive values in a column.
10. How would you identify the median value of a column in a table?
11. Write a query to find overlapping date ranges in a table.
12. Write a query to pivot a table's data from rows to columns.
13. Write a query to find rows where data in a specific column repeats after a certain number of rows.