If someone could help me i'm confused on the SQL commands to get the information i need for these if someone could help me ASAP!

Colonial Adventure Tours Use SQL and the Colonial Adventure Tours database (see Ch. 1 in your text) to complete the following exercises. Provide screenshots /snips of query outputs 1. 2. 3. 4. List the last name of each guide that does not live in Massachusetts (MA) List the trip name of each trip that has the type Biking. List the trip name of each trip that has the season Summer List the trip name of each trip that has the type Hiking and that has a distance longer than 10 miles Solmaris Condominium Group 1. List the owner number, last name, and first name of every condo owner. 2. List the complete LOCATION table (all rows and all columns). 3. List the last name and first name of every owner who lives in Bowton 4. List the last name and first name of every owner who does not live in Bowton. 5. List the location number and unit number for every condo whose square footage is equal to or less than 1,200 square feet