Create the following SQL script (Save as w6_firstname_lastname.sql) .

Create a simple Database with the following

1) Create insert script (10 inserts)

2) Create update script (10 updates)

3) Create the following inserts

a) Select all records

b) Select all records sorted descending , ascending

c) Select all records with condition (where)

d) Count all records

e) Count all record with condition

Create 3 delete scripts

Submit your week 6 work in w6_firstname_lastname.zip