black rock

Write a query to identify the employee(s) whose salary is closest to the average salary of the company.

This question was asked in Interview at black rock. The open position had a CTC of 26 LPA. Read more Company:…

3 months ago

Display all months where sales exceeded the average monthly sales.

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Display…

3 months ago

Find the most common value (mode) in a specific column.

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Find…

3 months ago

Retrieve the name of the manager who supervises the most employees

Company: BlackRock CTC: 26LPA Source: Linked Post Q. Retrieve the name of the manager who supervises the most employees. Solution: SELECT…

4 months ago

Identify products that were sold in all regions.

Query: SELECT product_id FROM sales GROUP BY product_id HAVING COUNT(DISTINCT region_id) = (SELECT COUNT(*) FROM regions); Explanation: We need to…

4 months ago