1. Find all capital cities that are one of the three largest cities in the state/province using intersect

Tables are set up like this 

Government Table
-State
-Capital
-Governor
-LowerHouse
-UpperHouse
-Country

Large Table
-State
-Firstcity
-SecondCity
-ThirdCity
-Country

Ticket to Ride Table
-State
-City
-Tickets
-Country
 

 

 

This is my query so far I need it working in Oracle:

SELECT FirstCity, SecondCity, ThirdCity 

FROM Large 

WHERE IN(Capital = FirstCity

 OR Capital = SecondCity 

OR Capital = ThirdCity) 

Intersect

SELECT Capital 

FROM Government 

WHERE IN(Capital = FirstCity 

OR Capital = SecondCity 

OR Capital = ThirdCity);

Answer rating: 100% (QA)

Your query is almost correct but you need to use the INTERSECT keyword correctly The ... View the full answer