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:-

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

4) Create 3 delete scripts

Remember that you need to create a table before you are inserting data into it. Your sql program/script should contain everything from creation to the queries.