Company: BlackRock CTC: 26LPA Source: Linked Post Q: Write a query to calculate the median salary of employees in a…
Query: SELECT product_id FROM sales GROUP BY product_id HAVING COUNT(DISTINCT region_id) = (SELECT COUNT(*) FROM regions); Explanation: We need to…