- 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
Your byte size news and commentary from Silicon Valley the land of startup vanities, coding, learn-to-code and unicorn billionaire stories.
Thursday, January 12, 2017
Codecademy SQL Table Transformation Subqueries Walkthrough
Subscribe to:
Post Comments (Atom)
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...

-
Can hack schools solve Silicon Valley's talent crunch? The truth about coding bootcamps and the students left behind http://t.co/xXNfqN...
-
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