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

by

This question was asked in Interview at black rock. The open position had a CTC of 26 LPA. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Write a query to identify the employee(s) whose salary is closest to the average salary of the company see this code on db-fiddle Solution Explanation In this … Read more

Display all months where sales exceeded the average monthly sales.

by
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 all months where sales exceeded the average monthly sales see this code on db-fiddle Solution Solution 1 Solution 2 Explanation Although there are multiple ways to solve this problem, using the CTE method stands out … Read more

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

by
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 the most common value (mode) in a specific column. See this code on db-fiddle Solution Explanation We have selected ProductName along with the count of rows as Frequency, grouping the data by ProductName. To display … Read more

Identify employees who have never received a performance review.

by
Identify employees who have never received a performance review.

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Identify employees who have never received a performance review. See this code on db-fiddle Solution Explanation It is a very Streight forward solution where a subquery is utilized to filter the employee records. Subquery contains the … Read more

Write a query to retrieve the first order placed by each customer.

by
Write a query to retrieve the first order placed by each customer.

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Write a query to retrieve the first order placed by each customer. see this code on db-fiddle Solution Solution 1 Solution 2 Solution 3 Explanation While there are multiple ways to solve this problem, but most … Read more