dbms task 4

Practice Queries : 

    1.  Find the names of sailors who have reserved boat number 103

    2.   Find the names of sailors who have never reserved boat number 103

    3.   Find the names of sailors who have reserved a red boat

    4. Find the names and ages of all sailors.

    5. Find all sailors with rating > 7.

    6.  Find the colors of boats reserved by Lubber

    7.  Find the names of sailors who have reserved at least one boat

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

    9.  Find the names of sailors who have reserved both a red and a green boat
 
    10.  Find the names of sailors who have reserved a red but not a green boat

    11.  Find the names of sailors who have reserved at least two different boats

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

    13.   Find the names of sailors who have reserved all boats

    14.  Find the names of sailors who have reserved all boats called Interlake

    15.  Find the sailor name boat id and reservation date for each reservation

    16.  Find sailors who have reserved all red boats

    17.   Find the sids of sailors who have reserved a red boat;

    18. Find the ages of sailors whose name begins and ends with B and has at least 3 characters.

    19.  Find the ages of sailors whose name begins and ends with B and has at least three characters

    20.  Find the sids of all sailors who have reserved red boats but not green boats

    21. Find the average age of all sailors

    22. Find the average age of sailors with a rating of 10

    23. Count the number of sailors

    24.  Count the number of different sailor names

    25.   Find the colors of boats reserved by Albert.