Ads Impression SQL Query

Assume there is an impressions table which contains ad display data with columns ad_id, timestamp, and user_id. Write an SQL query to compute the number of impressions for each ad. Sample Input: Table impressions: | ad_id | timestamp | user_id | |-------|----------------|---------| | 1 | 2023-07-15 10:00:00 | 101 | | 1 | 2023-07-15 10:05:00 | 102 | | 2 | 2023-07-15 11:00:00 | 101 | Expected Output: | ad_id | impression_count | |-------|------------------| | 1 | 2 | | 2 | 1 | Example Input CREATE TABLE impressions (ad_id INT, timestamp DATETIME, user_id INT); INSERT INTO impressions VALUES (1, '2023-07-15 10:00:00', 101), (1, '2023-07-15 10:05:00', 102), (2, '2023-07-15 11:00:00', 101);