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. List the trip ID and trip name...

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.

List the trip ID and trip name for all trips that start in Bar Harbor. Your query should ignore

case. 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.