sql interview questions - CuriousClub.in

Write a query to calculate the median salary of employees in a table.

January 16, 2025January 3, 2025 by Vishal

Company: BlackRock CTC: 26LPA Source: Linked Post Q: Write a query to calculate the median salary of employees in a table. Solution: Explanation: Here we need to find out the …

Identify products that were sold in all regions.

January 16, 2025January 3, 2025 by Vishal

Query: SELECT product_id FROM sales GROUP BY product_id HAVING COUNT(DISTINCT region_id) = (SELECT COUNT(*) FROM regions); Explanation: We need to find products that have been sold in all regions. This …