-- The purpose of this query is to join all 'daily' information into a single query for easiness and comprehension. -- In this query: primary table is 'daily intensity' measure, joined with daily caloric measurement and steps taken as foreign tables. SELECT * FROM `capstone-project-track-1.intensities_data.daily_intensities` AS daily_intensities -- activity/intensity table JOIN `capstone-project-track-1.calories_data.daily_calories`AS daily_calories -- calories table ON daily_intensities.Id = daily_calories.Id AND daily_intensities.ActivityDay = daily_calories.ActivityDay JOIN `capstone-project-track-1.steps_data.daily_steps`AS daily_steps -- steps table ON daily_intensities.Id = daily_steps.Id AND daily_intensities.ActivityDay = daily_steps.ActivityDay ORDER BY daily_intensities.ActivityDay
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter