CTE

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

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