WRITE A SQL QUERY THAT WOULD ANSWER THE FOLLOWING QUESTIONS

1. Display the order date and ship date for all orders shipped to Atlanta and Austin. Create three different queries to accomplish this task:

a. a search pattern operation LIKE,

b. a logical operator OR, and

c. the IN operator.

2. Use a search pattern to find customers with last name that starts with MC. List each customers first name,last name and city.

3. Modify Query #2 (the one above) to display the customers with the following format Last Name, First Name city.