Data Analyst SQL Interview Questions | EY (Ernst & Young) | Shared By An Experienced Data Analyst

10 months ago

This article tackles common SQL Interview Questions asked by EY, offering detailed solutions and explanations to help aspiring data analysts…

1164 Product Price at a Given Date

10 months ago

1164. Product Price at a Given Date: Learn how to track and select price from continuously changing series. Read more Company:…

1661 Average Time of Process per Machine

10 months ago

1661 Average Time of Process per Machine: This is a really interesting question where we write a compact code of…

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

10 months ago

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

Display all months where sales exceeded the average monthly sales.

10 months ago

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

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

10 months ago

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

Identify employees who have never received a performance review.

10 months ago

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

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

10 months ago

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

SQL Natural Join

10 months ago

What is SQL Natural Join? Natual Join is a type of join in SQL which combines row from 2 tables…

Display the cumulative percentage of total sales for each product.

10 months ago

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