cswork / 题目类别打开练习工作台

按题目类别

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

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

面试题
574
最近更新
2026-10-06

面试题 574

在工作台筛选
  1. 面试Calculate the Percentage of Highly Active Users by Country · Pinterest中等
  2. 编程Count Users Retained on Day Seven · Mixpanel中等
  3. 编程Count Users Active After Signup · Mixpanel中等
  4. 编程Compare First-Week Retention by Plan Type · Mixpanel中等
  5. 编程Calculate First-Week Retention by Signup Cohort · Mixpanel中等
  6. 编程Number Entries Within Each Conversation中等
  7. 编程Continue Entry Numbers for a Daily Incremental Batch中等
  8. 编程Sum Employee Working Time from Ordered Check-In and Check-Out Events · Agoda简单
  9. 编程Return Every Employee with a Mapped or Default Unique ID · Agoda简单
  10. 编程Rank Customers by Monthly Revenue with Competition Ties · Agoda简单
  11. 编程Find the Longest Calendar-Day Streak with All Employees Present · Agoda简单
  12. 编程SQL: Users With No Rides in the Most Recent 7-Day Window, Including Non-Riders · Waymo中等
  13. 编程SQL: Top 5 Vehicle Models by Miles per kWh Under a Maintenance Cost Cap · Waymo中等
  14. 编程SQL: Monthly Ride Totals and Average Ratings, Newest Month First · Waymo中等
  15. 编程SQL: Count Users With Zero or One Rides per City · Waymo中等
  16. 编程SQL: Average Ride Rating in Users' First and Third Active Months by City · Waymo中等
  17. 编程Classify Tree Nodes in SQL · Oracle中等
  18. 编程Aggregate User Events and Check Join Uniqueness · Mixpanel中等
  19. 编程Longest Meeting-Free Business-Hours Block per Employee and Day · Intuit中等
  20. 编程Find Users with Seven Consecutive Impression Days · Airbnb中等
  21. 编程Find Hosts Meeting Listing, Rating, and Review-Coverage Rules · Airbnb中等
  22. 编程Estimate Page-Visit Duration from the Next User Event · Airbnb中等
  23. 编程Calculate the Median House Price in Each City · Airbnb中等
  24. 编程Find Values Owned Only by the Selected User · Meta中等
  25. 编程Reconcile Monthly Bank-Account Balances Across Two Datasets · Stripe中等
  26. 编程Find the Latest Balance for a Bank Account · Stripe中等
  27. 编程Find Customers Whose Average Website Resource Usage Exceeds 50 Percent · IBM中等
  28. 编程Measure Customers Ordering from Bottom-Quartile Restaurants · DoorDash简单
  29. 编程Compute ad impression conversion rates · Meta中等
  30. 编程Compute a Seven-Day Rolling Average · Fetch Rewards中等
  31. 编程Calculate Order Request Metrics · DoorDash困难
  32. 编程Find top advertisers and cost per KPI · Moloco中等
  33. 编程Count unconnected posts and reactions · Meta中等
  34. 编程Campaign Efficiency Metrics and Below-Average CTR · ByteDance中等
  35. 编程Find the Highest-Paid Employee in Each Department · Otter.Ai中等
  36. 编程Find Every Project with the Most Employees · Otter.Ai中等
  37. 编程Compute a Seven-Day Rolling Average · Whatnot中等
  38. 编程Compute High-Call Usage Rates · Meta困难
  39. 编程Analyze spend cohort and source shifts · Meta中等
  40. 编程Analyze document collaboration from CSV logs · Notion简单
  41. 编程Explain Pandas and SQL Basics · Rbcroyalbank简单
  42. 面试Solve SQL and Python OA tasks · Wayfair简单
  43. 编程Find Lowest Prices for Highly Rated Categories · Capital One中等
  44. 编程Debug SQL join that drops rows · Home Depot简单
  45. 编程Compute Cohort Retention Rate · Intuit中等
  46. 编程Differentiate pandas objects and SQL filters · Rbcroyalbank简单
  47. 编程Compute multi-account user distribution and unread pct · Meta简单
  48. 面试Analyze member video posting behavior by country · LinkedIn简单
  49. 编程Find top countries by population per continent · LinkedIn简单
  50. 编程Compute each member’s current notification status · LinkedIn简单
  51. 编程Compute article-type diversity per user and histogram · LinkedIn简单
  52. 编程Posts and Replies Engagement · Meta中等
  53. 编程Find multi-account buckets and unread rate · Meta中等
  54. 编程Write SQL for Pixel Signal Metrics · Meta中等
  55. 编程Convert Dictionary to DataFrame · Walmart Labs困难
  56. 编程Write SQL for content-view analytics · The New York Times简单
  57. 编程Compute per-coin quarterly amounts and totals · Others简单
  58. 编程Compute ads revenue by geography in SQL · Meta简单
  59. 编程Write SQL for call analytics · Meta中等
  60. 编程Explain pandas and SQL basics · Rbcroyalbank简单