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

Debug Google Cloud Error - Failed to enable API please make sure you have the IAM permission to enable API

 If you are not expecting this message,  and think you have the permission to enable API read on. Before using Google Cloud services, genera...