- 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
Ad
Thursday, January 12, 2017
Codecademy SQL Table Transformation Subqueries Walkthrough
Subscribe to:
Post Comments (Atom)
Applying to Graduate School Master Degree and PhD
After transitioning to machine learning, I had to learn it the hard way that it is now very competitive and difficult to get into graduate s...
-
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... -
The bogus request from P2PU to hunt for HTML tags in real life has yielded a lot of good thoughts. My first impression was that this is stup...
No comments:
Post a Comment