t1.timestamp::date as date, -- Command :: converts "timestamp" to just the date min(t2.timestamp::TIMESTAMP) - max(t1.timestamp::TIMESTAMP) as session_duration -- Converting "timestamp" to just the ...

105_Marketing Campaign Success_Advanced (stratascratch).sql 106_Find the total number of downloads for paying and non-paying users by date (stratascratch).sql 107_number of shipments per month ...