SQL · Meta · Hard
Write a SQL query for a trust and safety team that measures the prevalence of policy-violating content views during a seven-day review window. Assume today is 2025-11-05. The reporting window is 2025-10-30 through 2025-11-05, inclusive. For each view_date and country, return the following columns: view_date country total_views violating_views_ex_ante violating_views_ex_post ex_ante_prevalence ex_post_prevalence Definitions: Ex-ante classification: A view is violating only…
Checking your access…