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

40 questions

  1. 1What is the best way to connect SQL databases and why?MediumTechnicalData· Airbnb, Google
  2. 2Write a query to find the top 3 unique salaries in each department and list all employees who have those salaries.MediumCodingData· Amazon
  3. 3Given a bookstore database schema, write SQL queries using joins and aggregations to answer questions about sales, inventory, and customer data.MediumCodingData· Meta
  4. 4Calculate Test ScoresMediumCodingData· Google
  5. 5Find the number of users who called three or more people in the last week.MediumCodingData· Meta
  6. 6Explain the key differences between BETWEEN and HAVING clauses in SQL.MediumTechnicalData· Deloitte
  7. 7What is the difference between NoSQL and SQL?MediumTechnicalData· Amazon, Apple
  8. 8What percentage of users who were active on Messenger yesterday made a video call yesterday?MediumCodingData· Meta
  9. 9Remove Duplicate EmailsMediumCodingData· IBM
  10. 10Write SQL code to publish the Fibonacci series.MediumCodingData· Google, Microsoft
  11. 11Consecutive LoginsMediumCodingData
  12. 12Find Customers by DepartmentMediumCodingData
  13. 13Campaign Impact RankingMediumCodingData
  14. 14E-commerce (3 of 5)MediumCodingData
  15. 15Employee Earnings.MediumCodingData
  16. 16EPA Temperature MonitoringMediumCodingData
  17. 17Find Campaign PurchasesMediumCodingData
  18. 18Find Conversion RatesMediumCodingData
  19. 19Find Customer Lifetime Value (LTV)MediumCodingData
  20. 20Find Revenue by DepartmentMediumCodingData
  21. 21Find Second Highest OrderMediumCodingData
  22. 22Fraudulent TransactionsMediumCodingData
  23. 23Instagram LikesMediumCodingData
  24. 24Marketing Channel AttributionMediumCodingData