Question 2:

sailors (sid, sname, rating, age)

reserved (sid, bid, day)

boats (bid, bname, color)

1. Find the names of the sailors who have reserved a red or green boat.

2. Find the names of the sailors with age over 20 who have not reserved a red boat.

3. Find the names of the sailor who have reserved all boats.

4. Find the color of the boat reserved by Smith.

Subject: Introduction to database system