black rock

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

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:…

2 months ago
Display all months where sales exceeded the average monthly sales.Display all months where sales exceeded the average monthly sales.

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…

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

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…

2 months ago
Retrieve the name of the manager who supervises the most employeesRetrieve the name of the manager who supervises the most employees

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…

3 months ago
Identify products that were sold in all regions.Identify products that were sold in all regions.

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…

3 months ago