AS region, EXACT_COUNT_DISTINCT(user_dim.device_info.resettable_device_id) as install_count FROM your_table_name WHERE user_dim.geo_info.country = 'Japan' AND event_dim.name = 'first_open' GROUP BY install_date, region ORDER BY install_date ASC, install_count DESC ಓݝผͷ%BJMZΠϯετʔϧΛऔಘ