Calculate survey response and quality metrics in SQL

Given the current date 2025-03-08, you must compute survey response-rate and quality metrics for the trailing seven-day window 2025-03-02 through 2025-03-08 (both endpoints included). Four event tables are available: impressions(impression_id BIGINT, user_id BIGINT, survey_id INT, ts TIMESTAMP), clicks(click_id BIGINT, impression_id BIGINT, ts TIMESTAMP), surveys(survey_id INT, version VARCHAR(10), active_from DATE), and survey_responses(response_id BIGINT, user_id BIGINT,…