1. Find all Canadian provinces not represented in Ticket To Ride. 2. Find all capital cities...

 

Transcribed Image Text:

1. Find all Canadian provinces not represented in Ticket To Ride. 2. Find all capital cities that are one of the three largest cities in the state/province. 3. Find all governmental units (e.g., New Hampshire Governor) that are under republican control. Note: To do that, you would want to return separate things for "House", "Senate", and "Governor". You will want to concatenate in your queries to help here (your column names are not your friends in this endeavor). 4. Find all cities in Ticket To Ride that are not one of the three biggest cities in their jurisdiction. 5. Find all states that have "The Trifecta", that all three state governmental institutions are under the same party's control. Do this using at least one union. 6. Find all third largest cities that are destinations in Ticket to Ride. 1. Find all Canadian provinces not represented in Ticket To Ride. 2. Find all capital cities that are one of the three largest cities in the state/province. 3. Find all governmental units (e.g., New Hampshire Governor) that are under republican control. Note: To do that, you would want to return separate things for "House", "Senate", and "Governor". You will want to concatenate in your queries to help here (your column names are not your friends in this endeavor). 4. Find all cities in Ticket To Ride that are not one of the three biggest cities in their jurisdiction. 5. Find all states that have "The Trifecta", that all three state governmental institutions are under the same party's control. Do this using at least one union. 6. Find all third largest cities that are destinations in Ticket to Ride.

Answer rating: 100% (QA)

Lets tackle these queries step by step Find all Canadian provinces not represent... View the full answer