Ad

Thursday, January 12, 2017

Codecademy SQL Table Transformation Subqueries Walkthrough


  • 1. Table Transformation
    • SELECT * FROM flights WHERE (SELECT code FROM airports WHERE elevation < 2000); 
    • Nested subqueries 
    • First get all the codes from airports table if its elevation is smaller than 2000
    • Use this as a filter to query all columns of data from the flights table
    • Don't forget the ; semicolon in the end

No comments:

Post a Comment

K mean clustering sklearn best practice - Udacity Machine Learning Nanodegree Unsupervised Learning

There are three key k means clustering parameters in sklearn that you will need to pay attention to: Number of centroids, aka center of c...