Question bank

4,310 interview questions, answered.

Reference answers, what the interviewer is really testing, how it is graded, and the follow-ups that come next.

Easy 14Medium 40Hard 15
Filters · onDifficulty, topic, company
Clear all

69 questions

  1. 1What is the best way to connect SQL databases and why?MediumTechnicalData· Airbnb, Google
  2. 2Session Data Analysis.HardCodingTechnical· Amazon
  3. 3Write a query to find all dates where the stadium had three or more consecutive days with attendance of 100 or more people.HardCodingData· Amazon
  4. 4Write a query to find the top 3 unique salaries in each department and list all employees who have those salaries.MediumCodingData· Amazon
  5. 5Given a bookstore database schema, write SQL queries using joins and aggregations to answer questions about sales, inventory, and customer data.MediumCodingData· Meta
  6. 6Calculate Test ScoresMediumCodingData· Google
  7. 7Find the number of users who called three or more people in the last week.MediumCodingData· Meta
  8. 8Explain the key differences between BETWEEN and HAVING clauses in SQL.MediumTechnicalData· Deloitte
  9. 9What is the difference between NoSQL and SQL?MediumTechnicalData· Amazon, Apple
  10. 10Find Monthly Revenue GrowthHardCodingData· Uber
  11. 11What percentage of users who were active on Messenger yesterday made a video call yesterday?MediumCodingData· Meta
  12. 12Monthly Post Success Analysis.EasyCodingData· LinkedIn
  13. 13Remove Duplicate EmailsMediumCodingData· IBM
  14. 14Write SQL code to publish the Fibonacci series.MediumCodingData· Google, Microsoft
  15. 15Top Salaries by DepartmentHardCodingData· Tesla
  16. 16Tree Node.EasyCodingData· Google
  17. 17What is SQL?EasyDataCoding· Microsoft
  18. 18Consecutive LoginsMediumCodingData
  19. 19E-commerce (2 of 5)EasyCodingData
  20. 20Employee HierarchyHardCodingData
  21. 21Find Customers by DepartmentMediumCodingData
  22. 22Total Transaction VolumeHardCodingData
  23. 23Amazon Order StatusHardCodingData
  24. 24Campaign Impact RankingMediumCodingData