I’m attempting to make a simple database using SQL script with the following conditions:

Create insert script      (10 inserts)

Create update script    (10 updates)

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

Does anyone have some sample code for me to learn from?