Skip to content

Instantly share code, notes, and snippets.

@crystalattice

crystalattice/SQL_queries.sql

Last active November 26, 2017 01:44
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save crystalattice/2bdecff6f95e5436a73f3cb4a9d945c2 to your computer and use it in GitHub Desktop.
Download ZIP
Unit 1, Lesson 2, Project 2
Raw
SQL_queries.sql
--part 1
SELECT
trip_id,
duration
FROM
trips
ORDER BY duration DESC
LIMIT 5
--part 2
SELECT
*
FROM
stations
WHERE station_id = 84
--part 3
SELECT
mintemperaturef
FROM
weather
WHERE
Events LIKE "Rain" AND
ZIP = 94301
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment