Types of Joins
Types of Joins
Quiz Summary
0 of 4 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 4 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 4
1. Question
What SQL would you write to get the average snowfall for all states? Do not use aliases. Only return states that gets snow.
CorrectIncorrect -
Question 2 of 4
2. Question
What SQL would you write to get the average snowfall for all states – this time use aliases – “s” for the States table and “w” for the Snow table.
CorrectIncorrect -
Question 3 of 4
3. Question
What SQL would you write to see which state all the presidents/other notables were born in? No aliases! Return state name, presidents place of birth and name. In that order :)
CorrectIncorrect -
Question 4 of 4
4. Question
Again – with aliases! “s” for States and “b” for BirthPlace
CorrectIncorrect
