In SQL

#1 Create a table called YOUR_NAME_BOAT containing the following fields:

Registration Number character 10 bytes Primary Key

Manufacturer character 20 bytes Not Null

Name character 20 bytes

Length numeric - three whole digits & one decimal point Not Null

Horsepower integer

* Registration numbers are in the format NY 1234 FF with embedded blanks and the first two letters identify the state

#2 Populate the table with five records.

#3 Change the horsepower field in the last record to a different value using a "where" clause to select the boat by its registration number

#4 Write a query and select all of the fields. Sort by the "length" field