Write SQL to perform the following queries and updates. You should test your script to make sure it runs without error:
a. Retrieve all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number.
b. Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.
c. Produce a list of your distributors and all their information sorted in order by company name.
d. Update customer names to change their maiden names to married names. You can choose which records to update.
e. Delete customers from the database. You can choose which records to delete.
How am I to conduct all of htis without using a program? The professor said to "simulate" and that it was ok to use Microsoft
Word.
Attached are my scripts (in a word document) and the ERD Diagram from my first project. Please review my scripts and help me to
match them with my ERD Diagram. Also please help me to complete the other areas of this assignment.
Attachment:- Aponte_Michael_Project2.doc
Attachment:- Aponte_Michael_ERD.zip