cswork / 公司打开练习工作台

按题目类别 · Meta

Meta 数据处理(SQL/Python) 面试题

Meta 数据处理(SQL/Python)类面试准备:147 道面试题,来自候选人真实面试。在 CSWork 阅读、练习、模拟。

面试题
147
最近更新
2026-09-20
  1. 编程Find Values Owned Only by the Selected User中等
  2. 编程Compute ad impression conversion rates中等
  3. 编程Count unconnected posts and reactions中等
  4. 编程Compute High-Call Usage Rates困难
  5. 编程Analyze spend cohort and source shifts中等
  6. 编程Compute multi-account user distribution and unread pct简单
  7. 编程Posts and Replies Engagement中等
  8. 编程Find multi-account buckets and unread rate中等
  9. 编程Write SQL for Pixel Signal Metrics中等
  10. 编程Compute ads revenue by geography in SQL简单
  11. 编程Write SQL for call analytics中等
  12. 面试Compute seller counts and vehicle share中等
  13. 面试Compute Heavy-Caller Percentages困难
  14. 编程Compute reply-based user metrics in 7 days简单
  15. 编程Compute percent of active users with 50+ calls简单
  16. 编程Compute active ad revenue by creation source简单
  17. 面试Compute ad revenue metrics by geography in SQL中等
  18. 编程Write SQL to analyze shop visibility中等
  19. 编程Write SQL to compare social-only vs game-only engagement中等
  20. 编程Write SQL/pandas for KPI anomaly中等
  21. 编程Write SQL for daily chats and fast replies中等
  22. 编程Define and query shop visibility中等
  23. 编程Write SQL for hashtag source and safety rates中等
  24. 面试Write dating profile report with final reviews中等
  25. 编程Write SQL filtering, grouping, CASE, UNION tasks中等
  26. 编程Compute cohort GMV and payer rate with edge cases中等
  27. 编程Compute video-call SQL metrics with edge cases中等
  28. 编程Compute CTR overall and by campaign type中等
  29. 编程Write SQL to analyze group-call concurrency中等
  30. 编程Compute unconnected 60s posts and reactions averages中等
  31. 编程Write SQL for visibility, calls, and cohort activity中等
  32. 编程Calculate survey response and quality metrics in SQL中等
  33. 编程Define and compute shop visibility in SQL中等
  34. 编程Write SQL for retention, conversion, and churn中等
  35. 编程Write SQL to compare exclusive category engagement中等
  36. 编程Write SQL for shop visibility and activity metric中等
  37. 编程Compute unread and multi-account user percentages中等
  38. 编程Compute survey rates and bias-correct ratings中等
  39. 编程Write SQL for hashtag analytics and joins中等
  40. 编程Write SQL to localize anomaly and funnel中等
  41. 编程Label new vs old users over time in SQL中等
  42. 编程Write SQL for engagement and attribution KPIs中等
  43. 编程Calculate posts per DAU by country today中等
  44. 编程Compute daily post success rate for last 7 days中等
  45. 编程Write SQL to compute shop visibility share中等
  46. 编程Write SQL with HAVING and efficient joins中等
  47. 编程Produce dating profile funnel report by cohort中等
  48. 编程Compute French DAU video-call percentage yesterday中等
  49. 编程Compute callers contacting >3 people last 7 days中等
  50. 编程Write SQL for 7-day WhatsApp call metrics中等
  51. 编程Write SQL for revenue and advertiser analyses中等
  52. 编程Write SQL to analyze Group Calls adoption中等
  53. 编程Write SQL for initiators and French DAU%中等
  54. 编程Define and analyze new-vs-existing activity中等
  55. 编程Write SQL for comment analytics中等
  56. 编程Write advanced SQL for sales support analytics中等
  57. 编程Compute shop visibility and intent metrics in SQL中等
  58. 编程Write SQL to infer group-call demand中等
  59. 编程Write SQL for social feed metrics and ties中等
  60. 编程Compute multi-account activity and unread percentages in SQL中等