create sql script

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

4) Create 3 delete scripts