Create the following SQL script (Save as w6_firstname_lastname. sql) .Create a simple Database with the following1) Create insert script (10 inserts)2) Create update script (10 updates)3) Create the following insertsa) Select all recordsb) Select all records sorted descending , ascendingc) Select all records with condition (where)d) Count all recordse) Count all record with conditionCreate 3 delete scripts