I need help writing this program. I already have the database I will be using. The name of the database is Flights.

please use SELECT, INSERT, UPDATE, or DELETE statements to identify and correct data issues.

1. Write a script to select all data from the planes table.

2. Update the planes table so that rows that have no year will be assigned the year 2013. (missing values will display as NULL).

3. Insert a new record to the planes table with the following values:

Tailnum: N15501

Year: 2013

type: Fixed wing single engine

Manufacturer: BOEING

Model: A222-101

Engines: 3

Seats: 100

Speed: NULL (notice this is not a text value but truly the absence of any value: "empty". As such, don't use single or double quotes around NULL when inserting this value).

Engine: Turbo-fan

4. Delete the newly inserted record on step 3.