cswork / 公司打开练习工作台

按题目类别 · Amazon

Amazon 数据处理（SQL/Python） 面试题

Amazon 数据处理（SQL/Python）类面试准备：60 道面试题，来自候选人真实面试。在 CSWork 阅读、练习、模拟。

面试题
60
最近更新
2026-06-15

面试题 60

在工作台筛选
  1. 编程Find recommended friend pairs by shared listening简单
  2. 编程Find daily first-order merchants with SQL中等
  3. 编程Design student–course data models and SQL中等
  4. 面试Implement robust word counts and min/max中等
  5. 编程Compute join counts and window ranks中等
  6. 编程Design idempotent daily loads with deduping中等
  7. 编程Diagnose MySQL joins and GROUP BY/HAVING errors中等
  8. 编程Build DiD dataset with SQL中等
  9. 编程Append country tables and rank salaries in USD中等
  10. 编程Transform event logs with subscription windows in pandas中等
  11. 编程Find top-spend categories per customer with ranking中等
  12. 编程Transform retail data with pandas groupby/merge/concat中等
  13. 编程Verify subscriptions and analyze orders with SQL/Python中等
  14. 编程Compute daily work hours from in/out events中等
  15. 编程Calculate cross-channel login user proportions中等
  16. 编程Design SQL/Pandas aggregations on retail schema中等
  17. 面试Build DID panel and compute effects in SQL中等
  18. 面试Process real-time enter/exit events and actives中等
  19. 编程Find returning users from access logs中等
  20. 编程Manipulate time-series with Pandas groupby中等
  21. 编程Understand SQL: DELETE vs TRUNCATE, VIEW vs TABLE, CROSS JOIN中等
  22. 编程Select Top Customers Using Transaction Data Filters中等
  23. 编程List Top Customers and Monthly Order Counts in SQL中等
  24. 编程Identify Key Metrics for Monitoring Shipment Defects中等
  25. 编程Find Top-3 Salaries Per Department Using SQL中等
  26. 编程Explain MySQL to MS SQL Server query syntax differences.中等
  27. 编程Ensure Correct Numeric Ordering in Visit ID Comparison中等
  28. 编程Derive Key Business Metrics Using SQL or Python中等
  29. 编程Create SQL Queries for Sales and Customer Analysis中等
  30. 编程Create Country-Level Spend Report Using Pandas中等
  31. 编程Compute 3-Day Rolling Revenue Averages with Pandas中等
  32. 编程Calculate Weekly, Monthly Hours Watched by Premium Users中等
  33. 编程Calculate Monthly Revenue from Orders in 2023中等
  34. 编程Calculate Defect Rate and Identify Top Lanes for Carriers中等
  35. 编程Analyze User Engagement with SQL Queries中等
  36. 编程Analyze Monthly Prime vs Non-Prime Sales and Price Buckets中等
  37. 编程Compute unique visitors by department中等
  38. 编程Illustrate SQL Join Results with Duplicate Keys中等
  39. 编程Identify Unique Unordered City Pairs in Flight Log中等
  40. 编程Identify Top Spenders and Segment Customers Using Python中等
  41. 编程Identify SQL Joins and Correct Query Errors中等
  42. 编程Identify Frequent Actor-Director Collaborations in Film Database中等
  43. 编程Identify First Daily Order for Each Merchant中等
  44. 编程Identify Employees with Invalid Department References中等
  45. 编程Identify Date with Highest Total kWh Consumption Using Pandas中等
  46. 编程Identify Customers Purchasing Every Product in Catalog中等
  47. 编程Find Top Three Books by City in Recent Months中等
  48. 编程Explore Subscription Patterns and Status Transitions with SQL/Pandas中等
  49. 编程Design Incremental Load Process for Large Relational Table中等
  50. 编程Create Monthly Revenue Report for Each Department中等
  51. 编程Count Customers Buying Both 'Kindle' and 'Alexa'中等
  52. 编程Consolidate and Rank Global Salaries in USD中等
  53. 编程Compute First Order Proportions by Day and Category中等
  54. 编程Calculate Weekly, Monthly Watch Hours for Paid Users中等
  55. 编程Calculate Weekly Event Sums from Daily Counts中等
  56. 编程Calculate Rolling 7-Day Sum of Answers by Device中等
  57. 编程Calculate Regional Revenue and Identify Top Customers中等
  58. 编程Analyze Top Book Sales and Unique Customer Purchases中等
  59. 编程Analyze Seller Compliance and Customer Purchase Patterns中等
  60. 编程Identify Top-Buying Customers Daily with SQL Query中等