Data Engineer SQL Interview Questions

Review this list of sql data engineer interview questions and answers verified by hiring managers and candidates.

+ Add interview

Product

Engineering

Operations

Design

Marketing

Data

Sales

Finance

Consulting

Security

Add interview

Data Engineer Data Analyst Data Scientist Software Engineer Backend Engineer Product Analyst Frontend Engineer Engineering Manager Solutions Architect QA Engineer

Asked at Amazon • 4 months ago
Write a query to find the top 3 unique salaries in each department and list all employees who have those salaries.
Data Engineer
SQL
+1 more
5 answers I was asked this
+2
"select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"
Sreeram reddy B. - "select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"See full answer
Data Engineer
SQL
+1 more
Asked at Meta (Facebook) • 4 months ago
Given a bookstore database schema, write SQL queries using joins and aggregations to answer questions about sales, inventory, and customer data.
Data Engineer
SQL
+1 more
1 answer I was asked this
"SELECT s.Sale_Date, SUM(si.Quantity * si.SalePrice) AS TotalRevenue FROM Sales s JOIN SaleItems si ON s.SaleID = si.Sale_ID GROUP BY s.Sale_Date ORDER BY s.Sale_Date; "
Bala G. - "SELECT s.Sale_Date, SUM(si.Quantity * si.SalePrice) AS TotalRevenue FROM Sales s JOIN SaleItems si ON s.SaleID = si.Sale_ID GROUP BY s.Sale_Date ORDER BY s.Sale_Date; "See full answer
Data Engineer
SQL
+1 more
Asked at Amazon • 4 months ago
Write a query to find all dates where the stadium had three or more consecutive days with attendance of 100 or more people.
Data Engineer
SQL
+1 more
2 answers I was asked this
"How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)? 1 Follow Request Answer More All related (34) Recommended 📷 Trausti Thor Johannsson · Follow Been using MySQL for more than 16 yearsDec 27 There are functions like DATEDIFF but there are also BETWE"
Hayatu H. - "How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)? 1 Follow Request Answer More All related (34) Recommended 📷 Trausti Thor Johannsson · Follow Been using MySQL for more than 16 yearsDec 27 There are functions like DATEDIFF but there are also BETWE"See full answer
Data Engineer
SQL
+1 more

🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

Showing 1-3 of 3

Interviewed recently?

Help improve our question database (and earn karma) by telling us about your experience

Trending companies

Data Engineer SQL Interview Questions

Write a query to find the top 3 unique salaries in each department and list all employees who have those salaries.

Given a bookstore database schema, write SQL queries using joins and aggregations to answer questions about sales, inventory, and customer data.

Write a query to find all dates where the stadium had three or more consecutive days with attendance of 100 or more people.

Explore questions by company

Explore questions by role