Skip to content

Instantly share code, notes, and snippets.

@crystalattice

crystalattice/Aggregate_SQL_Queries.sql

Last active November 26, 2017 02:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save crystalattice/eb0f640a2a9148adb8e5964a4369a7f2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save crystalattice/eb0f640a2a9148adb8e5964a4369a7f2 to your computer and use it in GitHub Desktop.
Download ZIP
Unit 1, Lesson 2, Project 3
Raw
Aggregate_SQL_Queries.sql
--Question 1
SELECT
Date,
Max(MaxTemperatureF) max_temp,
Zip
FROM
weather
--Question 2
SELECT
start_station,
COUNT(*) terminal_count
FROM
trips
GROUP BY
start_station
--Question 3
SELECT
MIN(duration)
FROM
trips
--Question 4
SELECT
AVG(duration),
end_station
FROM
trips
GROUP BY
end_station
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment