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

Deep Learning Papers that you must know!

Word embedding: Mikolov et al., 2013b; Pennington et al., 2014 word level embedding. One embedding per language versus LASER one embedding f...