Write SQL for hashtag analytics and joins

You are given an analytics schema for a social feed, and you should treat 2025-09-15 as "today". The tables are: Users(user_id INT, join_date DATE) Posts(post_id INT, author_id INT, created_at TIMESTAMP) PostHashtags(post_id INT, hashtag VARCHAR(50)) Impressions(user_id INT, post_id INT, seen_at TIMESTAMP) — one row means a user viewed a post once, and therefore was exposed to every hashtag that post carries HashtagClicks(user_id INT, post_id INT, hashtag VARCHAR(50),…