Multiple Joins
Multiple Joins
Quiz Summary
0 of 7 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 7 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
- 5
- 6
- 7
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 7
1. Question
What is the SQL to see all the States with their Cultural Description. Few rules:
- Pull state name from States, Description and Cultural Region Name from Cultural Lookup
- If you use table alias, use b for Birthplace, w for Snow, s for States, l for CultRegionLookup, r for Regions and c for CulturalRegions
- Put one space after commas and before and after =
- Make your SQL all on one line
CorrectIncorrect -
Question 2 of 7
2. Question
How many states have the word “cold” in their cultural description?
CorrectIncorrect -
Question 3 of 7
3. Question
What SQl did you use to see how many states have cold in their Cultural Description?
CorrectIncorrect -
Question 4 of 7
4. Question
How many states have the word “away”?
CorrectIncorrect -
Question 5 of 7
5. Question
What SQL did you use for the previous question?
CorrectIncorrect -
Question 6 of 7
6. Question
Which Region or Regions has “mix” in cultural description.
CorrectIncorrect -
Question 7 of 7
7. Question
What is the SQL – pull from tables (that are needed!) in this order: State, CultRegionLookup, CulturalRegion, Region, Birthplace, Snow
CorrectIncorrect
