Define and query shop visibility

Two tables are available for this exercise, shops and product_impressions, defined as follows: shops(shop_id INT, shop_name VARCHAR(50), country VARCHAR(2)) product_impressions(session_id VARCHAR(50), ts TIMESTAMP, product_id INT, shop_id INT, page VARCHAR(50), rank INT) A small illustrative sample of each table: For any shop, the daily Shop Visibility Score (SVS) on a UTC calendar day is built from sessions as follows. A session belongs to that day's population only if it…