Discuss the below:
Create SQL commands to response the following questions from the tables in the MembersSQL database as shown below
1. Show all columns and all records in the MemberType table.
2. Show all the columns from the Payments table where the payment date is 5/23/2013.
3. Display the first name, last name, city, state, and phone number for every member with the initials A.C. that lives in California.
4. Display the first name, last name, and fax number for all fax numbers that end with 5278.
5. Display the first name, last name, city, and phone number for all members from California with a first name that is either Don, Donald, Ron, or Ronald.
6. Show first name, last name, address, city, state, and zip for all members that live in either California or in Oregon.
7. Show first name, last name, address, city, and state for all members that live in Albany, CA.
8. Show all the columns from the payments table for payments made in March 2014 where the payment was either $35 or $50.
9. Provide a list of cities in the Members table that have a zip that begins with ‘99'. Show the city and state and show each city one time only.
10. List first name, last name, and fax number for all members whose fax number includes prefix