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

What is a Neural Network - Best Machine Learning Tutorials

Neural networks are important for ML as well as artificial intelligence and deep learning. This Youtube channel explains NN in depth. Take a...