Technical

An order table contains customer IDs, order dates, product IDs, and quantities. Write a query to find the top 3 selling products overall.

Business Intelligence Engineer

Amazon

Did you come across this question in an interview?

Your answer

  • An order table contains customer IDs, order dates, product IDs, and quantities. Write a query to find the top 3 selling products overall.
  • Using order data, how would you write a query to find the three best-selling products?
  • Can you write an SQL query that returns the top 3 products by total quantity sold?
  • Suppose you have order details — how would you find the top 3 products in terms of sales volume?
  • From an orders table with quantities, write a query to get the top 3 most sold products.
  • How would you use SQL to identify the highest-selling 3 products across all time?
  • Given order info, how do you rank products by units sold and return the top 3?
  • What SQL query would you write to find the top 3 products based on quantity ordered?
  • Write a query that returns the three most frequently purchased products using an order table.
  • How would you determine the top 3 performing products using quantity data in an orders table?
  • Can you show how you'd find the best-selling three products overall using basic order info?
Try Our AI Interviewer

Prepare for success with realistic, role-specific interview simulations.

Try AI Interview Now

Interview question asked to Business Intelligence Engineers interviewing at Amazon: An order table contains customer IDs, order dates, product IDs, and quantities. Write a query to find the top 3 selling products overall..