interview questions

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

by
calculate the median salary of employees in a table

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 median salary from the employees table. To calculate the median salary, we need some essential information, like the total number of employees in the table. … Read more

Identify products that were sold in all regions.

by

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 involves comparing the distinct regions a product appears in with the total number of regions available. Here’s how the query works step-by-step: Key Points: Example: … Read more

Exit mobile version