Answered step by step
Verified Expert Solution
Question
1 Approved Answer
example of column names: SELECT country_id, region_id FROM countries e1 WHERE region_id = (SELECT region_id, country_id FROM countries e2 WHERE e1.country_id = e2.country_id); Using Subquery,
example of column names: SELECT country_id, region_id FROM countries e1 WHERE region_id = (SELECT region_id, country_id FROM countries e2 WHERE e1.country_id = e2.country_id);
- Using Subquery, show the names of countries and regions that are part of Europe and Asia (10 points)
SQL Statement |
|
Result Screenshot |
|
- Using Subquery, show the names of countries and regions that are not part of Europe and Asia (Extra 5 points)
SQL Statement |
|
Result Screenshot |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started