- 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.
Ad
Thursday, January 12, 2017
Codecademy SQL Table Transformation Subqueries Walkthrough
Subscribe to:
Post Comments (Atom)
React UI, UI UX, Reactstrap React Bootstrap
React UI MATERIAL Install yarn add @material-ui/icons Reactstrap FORMS. Controlled Forms. Uncontrolled Forms. Columns, grid
-
This review is updated continuously throughout the program. Yay I just joined the Udacity Nanodegree for Digital Marketing! I am such an Uda...
-
All you need to know about Snap IPO. Tech startup news explained for Youtubers in minutes.
-
Codecademy AngularJS tutorial solution Part 3 Workflow .1 Adding a new product to $scope $scope helps the controller passes data to t...
No comments:
Post a Comment