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 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.

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.

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

Display the cumulative percentage of total sales for each product.

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Display the cumulative percentage of total sales for each product. sale_id product_id sales 1 101 500.00 2 102 300.00 3 103 200.00 4 101 400.00 5 102 600.00 6 103 800.00 7 104 1000.00 … Read more

Write a query to group employees by age ranges (e.g., 20–30, 31–40) and count the number of employees in each group.

This question was asked in Interview at black rock. read more Company: BlackRock CTC: 26LPA SQL Interview Question Question Q. Write a query to group employees by age ranges (e.g., 20–30, 31–40) and count the number of employees in each group. Solution age-range num_employee 21-30 7 31-40 6 41-50 5 51-60 2 View on DB … Read more

Exit mobile version