Skip to content

Instantly share code, notes, and snippets.

@omendezmorales

omendezmorales/suggested_query.sql

Created February 13, 2021 16:10
Show Gist options
  • Save omendezmorales/ce1a1dca11f0fc65a49221e64f06d9cc to your computer and use it in GitHub Desktop.
Save omendezmorales/ce1a1dca11f0fc65a49221e64f06d9cc to your computer and use it in GitHub Desktop.
Download ZIP
Project 1 Udacity
Raw
suggested_query.sql
SELECT
city_data.city AS "City Name",
city_data.year AS "Year",
city_data.avg_temp AS "City Avgerage Temp.",
global_data.avg_temp AS "Global Average Temp."
FROM
city_data
JOIN
global_data
ON
city_data.year = global_data.year
WHERE
city_data.city='Los Angeles'
@omendezmorales
Copy link
Author

More context in attached image

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment