Kind of confused with this if someone could help me step by step

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. List the last name of each guide that does not live in Massachusetts (MA). 2. List the trip name of each trip that has the type Biking. 3. List the trip name of each trip that has the season Summer. 4. 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 Bowten 4. List the last name and first name of every owner who does not live in Bowten 5. List the location number and unit number for every condo whose square footage is equal to or less than 1,200 square feet