SQL語法練習

找尋不重複使用者使用iphone && os_version >= “14”:
SELECT DISTINCT user_id FROM cloud.record WHERE device_type like “iPhone%” AND os_version >= “14”;

找尋不重複使用者使用iphone && os_version >= “14” && start_original > ‘2022-06-01’ (i.e. 3個月內有活動紀錄的人):
SELECT DISTINCT user_id FROM cloud.record WHERE device_type like “iPhone%” AND os_version >= “14” AND start_original > ‘2022-06-01’;

探索更多來自 LifeJourney 的內容

立即訂閱即可持續閱讀,還能取得所有封存文章。

Continue reading