- 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
Thursday, January 12, 2017
Codecademy SQL Table Transformation Subqueries Walkthrough
Drive PX 2 from NVIDIA specializes in smart car (the smart car fleet at NVIDIA is dubbed BB8) tasks and can be as small as the size of a lic...
This review is updated continuously throughout the program. Yay I just joined the Udacity Nanodegree for Digital Marketing! I am such an Uda...
In this downtown startup work space design the designers used fat boy bean bags and an extra wide step tiered staircase to create work space...
In this exercise 8/12, Codecademy requires you to do some basic arithmetics using Java. Use the plus symbol + for addition, the minus symbol...