Advanced Management Information Systems
Paper , Order, or Assignment Requirements
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.Hint: Use # for delimiters for dates.
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. Hint: Refer to the SQL 1 Video or slide deck for information on DISTINCT. ZIP codes are character data.
10. List first name, last name, and fax number for all members whose fax number includes prefix 448. (as in: 541-448-3432). Hint: Look for patterns within a column; don’t include phone numbers that have 448 somewhere else in the column.