cswork / 公司打开练习工作台

按题目类别 · TikTok / ByteDance

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

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

面试题
33
最近更新
2026-07-23

面试题 33

在工作台筛选
  1. 编程Campaign Efficiency Metrics and Below-Average CTR中等
  2. 编程Find top-paid employee per department中等
  3. 编程Find top-paid employee per department简单
  4. 编程Count buggy vs non-buggy by employer中等
  5. 编程Select max-discount product per category中等
  6. 编程Write SQL for 7-day geo-localized revenue dashboard中等
  7. 编程Compute and rank top bad advertisers中等
  8. 编程Analyze shopping funnel with joins and windows中等
  9. 编程Write SQL for geo posting-frequency drops中等
  10. 编程Compute last-to-previous ad impression gaps中等
  11. 编程Compute CTR drop with exclusions中等
  12. 编程Compare SQL counts, windows, and NULL semantics中等
  13. 编程Compute 7-day rolling complaint/order ratio in SQL中等
  14. 面试Calculate valid daily usage with gap constraints中等
  15. 编程Write SQL for last-7-day metrics without windows中等
  16. 编程Write SQL for TikTok Live creator metrics简单
  17. 面试Discuss Python mutability, copying, and GIL中等
  18. 编程Debug a Hive Query for DAU中等
  19. 编程Debug a Hive query中等
  20. 编程Select 10% Users Randomly from User Table中等
  21. 编程Identify Repeat Advertisers from Consecutive Weeks中等
  22. 编程Calculate Monthly Conversion Rate and Average Order Value中等
  23. 编程Calculate Day-7 Retention Rate from User Post Data中等
  24. 编程Calculate Conversion Rate from Ad Clicks to Page Visits中等
  25. 编程Analyze Posting Behavior by Cohort and Date中等
  26. 编程Write complex SQL for cohorts and retention中等
  27. 编程Explain a SQL query result中等
  28. 编程Debug a Hive insert query中等
  29. 编程Identify Top Discounts and Monitor Code Submissions中等
  30. 编程Compute 7-Day Rolling Average of Unique Post Viewers中等
  31. 编程Calculate User Registration Date and 7-Day Retention Rate中等
  32. 编程Analyze and Clean European Ecommerce Sales Data中等
  33. 编程Tiktok DS Interview Questions中等