Write SQL queries for the given database.

Sailor (sid, sname, rating, age)

Boat (bid, bname, color)

Reserves (sid, bid, date)

i. Find the names of sailors who have reserved ‘red’ boat.

ii. Find the sailor (name) with highest rating.

iii. Find the average age of sailor.

iv. Find the age of youngest sailor for each rating level.

v. Add the new boat to database.

Assume any values for required attributes.

Consider the following tables:

Sailor

Boat

Reserves …