This class was created by Brainscape user Moe Doe. Visit their profile to learn more about the creator.
By:
Moe Doe
- decks
- flashcards
- learners
Decks in this class (11)
Task 2 Queries with constraints
Find the movie with a row id of 6,
Find the movies released in the y...,
Find the movies not released in t...
4
cards
Task 3 Queries with constraints (Pt. 2)
Find all the toy story movies,
Find all the movies directed by j...,
Find all the movies and director ...
4
cards
TASK 4 Filtering and sorting Query results
List all directors of pixar movie...,
List the last four pixar movies r...,
List the first five pixar movies ...
4
cards
Review: Simple SELECT Queries
List all the canadian cities and ...,
Order all the cities in the unite...,
List all the cities west of chica...
5
cards
TASK 6 Multi-table queries with JOINs
Find the domestic and internation...,
Show the sales numbers for each m...,
List all the movies by their rati...
3
cards
Task 7 OUTER JOINs
Find the list of all buildings th...,
Find the list of all buildings an...,
List all buildings and the distin...
3
cards
TASK 8 A short note on NULLs
Find the name and role of all emp...,
Find the names of the buildings t...
2
cards
Task 9 Queries with expressions
List all movies and their combine...,
List all movies and their ratings...,
List all movies that were release...
5
cards
TASK 10 Queries with aggregates (Pt. 1)
Find the longest time that an emp...,
For each role find the average nu...,
Find the total number of employee...
4
cards
Task 11 Queries with aggregates (Pt. 2)
Find the number of artists in the...,
Find the number of employees of e...,
Find the total number of years em...
3
cards
Task 12 Order of execution of a Query
Find the number of movies each di...,
Find the total domestic and inter...
2
cards
More about
SQL 1-18 Tasks
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Moe Doe's SQL 1-18 Tasks flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
assessment 1, task 1
- 3 decks
- 46 flashcards
- 3 learners
Decks:
Assessment 1 Task 1, Assessment 1 Task 2, Assessment 1 Task 3, And more!
SQL
- 5 decks
- 81 flashcards
- 276 learners
Decks:
Sql Basics, Fetch Data Insert Edit Rows And Tables, Filter Queries Operators And Wildcards, And more!
Theme 1 17/18
- 53 decks
- 779 flashcards
- 89 learners
Decks:
11b Dynamic, 11c New Business, 11d Creative Thinking, And more!
