T-Mobile Wi-Fi? 10:36 instructure-uploads.s3.amazonaws.com copy/paste and screen capture) to each question. Do NOT remove any existing content or images from this file. You MUST include both your SOL Command and Results from running that command in your response to each question. (4 pts) List the guide number, first name, and last name for all guides. The first name should appear in lowercase letters and the last name should appear in uppercase letters. "Character Functions" in your Put your SQL command and results here: 2. (4 pts) List the trip ID and trip name for all trips that start in Bar Harbor. Your query should ignore the case of how Bar Harbor is entered in the query. For example, a trip with the start location of Bar Harbor should be included as should trips whose start location is BAR HARBOR, Bar harbor, BaR HarBor, and so on. Hint: Check out section "Character Functions" in your eBook and Figure 8-1 Put your SQL command and results here: 3. (4 pts) Every guide receives their first review 6 months after their hire date. List the guide's last name, first name, hire date and his/her first review date. Use FIRST REVIEW DATE as the column title. Working with Dates" in your eBook and Figure &-3 T-Mobile Wi-Fi? 10:36 instructure-uploads.s3.amazonaws.com copy/paste and screen capture) to each question. Do NOT remove any existing content or images from this file. You MUST include both your SOL Command and Results from running that command in your response to each question. (4 pts) List the guide number, first name, and last name for all guides. The first name should appear in lowercase letters and the last name should appear in uppercase letters. "Character Functions" in your Put your SQL command and results here: 2. (4 pts) List the trip ID and trip name for all trips that start in Bar Harbor. Your query should ignore the case of how Bar Harbor is entered in the query. For example, a trip with the start location of Bar Harbor should be included as should trips whose start location is BAR HARBOR, Bar harbor, BaR HarBor, and so on. Hint: Check out section "Character Functions" in your eBook and Figure 8-1 Put your SQL command and results here: 3. (4 pts) Every guide receives their first review 6 months after their hire date. List the guide's last name, first name, hire date and his/her first review date. Use FIRST REVIEW DATE as the column title. Working with Dates" in your eBook and Figure &-3