SQL · Meta · Medium
Two tables are available. The shop_visibility table is a state log for shop profiles; each row stores a profile_id, a date, a ts, and an integer visibility where 0 means hidden and 1 means visible. The shop_details table contains one descriptive row per profile. Table schemas: shop_visibility(profile_id BIGINT, date DATE, ts TIMESTAMP, visibility INT) shop_details(profile_id BIGINT, shop_category VARCHAR(80), visible_days BIGINT, creation_date DATE) Use standard SQL,…
Checking your access…