Consider a database consisting of the following tables (relations):

SAILORS(sid, name, rating, age)

BOATS(bid, name, color)

RESERVED(sid, bid, day) Write SQL statement for each of the following queries.

(1) Find the bids of the boats whose name is storm.

(2) Find the bids of the boats whose name contains the string storm.

(3) Find the names of the sailors who have a rating of at least 5.

(4) Find the names of boats whose color is yellow.

(5) Find the names of the sailors who have a rating of at least 5 and reserved a red boat.