all companies

Amazon SQL interview questions

Operational and retail metrics — orders, sellers, delivery and top-N reports. Practice reconstructed Amazon-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.

sqlpandaspythoneasy2medium7hard2

typical interview loop

  1. 1.Recruiter screen
  2. 2.Online assessment or phone screen with SQL
  3. 3.Loop: SQL, Python, Leadership Principles behavioral
  • › Tie every answer back to a Leadership Principle.
  • › Ranking and top-N per group come up constantly.

most-tested topics

functions
3
HAVING
3
JOIN
2
dates
2
GROUP BY
2
math
2

Based on 11 reconstructed Amazon-style questions.

practice path

1 free · 10 Pro
type
level
  1. 1Products above average pricesqleasy
  2. 2Units sold per categorysqleasy
  3. 3Buy Box win rate and price gappandasmedium
  4. 4Fulfilment centre late-shipment ratesqlmedium
  5. 5Prime delivery promisepythonmedium
  6. 6Products with verified reviewssqlmedium
  7. 7Verified-only ratingssqlmedium
  8. 8Weighted product ratingpythonmedium
  9. 9Weighted review scorepythonmedium
  10. 10Frequently bought togethersqlhard
  11. 11Monthly revenue growthsqlhard

Unlock all 11 Amazon questions with Pro.

upgrade