MariaDB [textbook]> #11. For every boat, list the marina number, slip number, boat name, owner number, owner’s first name, and owner’s last name.

MariaDB [textbook]> describe A_MARINA_SLIP;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| SLIP_ID    | decimal(4,0) | NO   | PRI | NULL    |       |
| MARINA_NUM | char(4)      | YES  | MUL | NULL    |       |
| SLIP_NUM   | char(4)      | YES  |     | NULL    |       |
| LENGTH     | decimal(4,0) | YES  |     | NULL    |       |
| RENTAL_FEE | decimal(8,2) | YES  |     | NULL    |       |
| BOAT_NAME  | char(50)     | YES  |     | NULL    |       |
| BOAT_TYPE  | char(50)     | YES  |     | NULL    |       |
| OWNER_NUM  | char(4)      | YES  | MUL | NULL    |       |
+------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

MariaDB [textbook]> describe A_OWNER;
+------------+----------+------+-----+---------+-------+
| Field      | Type     | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+-------+
| OWNER_NUM  | char(4)  | NO   | PRI | NULL    |       |
| LAST_NAME  | char(50) | YES  |     | NULL    |       |
| FIRST_NAME | char(20) | YES  |     | NULL    |       |
| ADDRESS    | char(15) | YES  |     | NULL    |       |
| CITY       | char(15) | YES  |     | NULL    |       |
| STATE      | char(2)  | YES  |     | NULL    |       |
| ZIP        | char(5)  | YES  |     | NULL    |       |
+------------+----------+------+-----+---------+-------+
7 rows in set (0.00 sec)

MariaDB [textbook]> #11. For every boat, list the marina number, slip number, boat name, owner number, owner’s first name, and owner’s last name.

MariaDB [textbook]> select MARINA_NUM, SLIP_NUM, BOAT_NAME, m.OWNER_NUM, FIRST_NAME, LAST_NAME from A_MARINA_SLIP m left join A_OWNER on m.OWNER_NUM = A_OWNER.OWNER_NUM;
+------------+----------+--------------+-----------+----------------+-----------+
| MARINA_NUM | SLIP_NUM | BOAT_NAME    | OWNER_NUM | FIRST_NAME     | LAST_NAME |
+------------+----------+--------------+-----------+----------------+-----------+
| 1          | A1       | Anderson II  | AN75      | Bill           | Anderson  |
| 1          | A2       | Our Toy      | EL25      | Sandy and Bill | Elend     |
| 1          | A3       | Escape       | KE22      | Alyssa         | Kelly     |
| 1          | B1       | Gypsy        | JU92      | Maria          | Juarez    |
| 1          | B2       | Anderson III | AN75      | Bill           | Anderson  |
| 2          | 1        | Bravo        | AD57      | Bruce and Jean | Adney     |
| 2          | 2        | Chinook      | FE82      | Daniel         | Feenstra  |
| 2          | 3        | Listy        | SM72      | Becky and Dave | Smeltz    |
| 2          | 4        | Mermaid      | BL72      | Mary           | Blake     |
| 2          | 5        | Axxon II     | NO27      | Peter          | Norton    |
| 2          | 6        | Karvel       | TR72      | Ashton         | Trent     |
+------------+----------+--------------+-----------+----------------+-----------+
11 rows in set (0.00 sec)

MariaDB [textbook]>  #12. For every service request for routine engine maintenance, list the slip ID, the description, and the status. 
MariaDB [textbook]> # category descripton "routine engine maintenance" is in A_SERVICE_CATEGORY
MariaDB [textbook]> # three list items in A_SERVICE_REQUEST basic = (subquery A_SERVER_CATEGORY)
MariaDB [textbook]> select SLIP_ID, DESCRIPTION, STATUS
 from A_SERVICE_REQUEST
 where CATEGORY_NUM = (select CATEGORY_NUM from A_SERVICE_CATEGORY where CATEGORY_DESCRIPTION = "Routine engine maintenance");
+---------+---------------------------------------------------------------------------------------------+----------------------------------+
| SLIP_ID | DESCRIPTION                                                                                 | STATUS                           |
+---------+---------------------------------------------------------------------------------------------+----------------------------------+
|       4 | Oil change and general routine maintenance (check fluid levels, clean sea strainers, etc.). | Service call has been scheduled. |
+---------+---------------------------------------------------------------------------------------------+----------------------------------+
1 row in set (0.00 sec)

MariaDB [textbook]> #13. For every service request for routine engine maintenance, list the slip ID, marina number, slip number, estimated hours, spent hours, owner number, and owner’s last name. 


MariaDB [textbook]> select s.SLIP_ID, MARINA_NUM, SLIP_NUM, s.EST_HOURS,
                    s.SPENT_HOURS, o.OWNER_NUM, LAST_NAME, FIRST_NAME
		    from A_SERVICE_REQUEST s, A_MARINA_SLIP, A_OWNER o
		    where s.SLIP_ID = A_MARINA_SLIP.SLIP_ID and
		    A_MARINA_SLIP.OWNER_NUM = o.OWNER_NUM   and
		    s.CATEGORY_NUM =
(select CATEGORY_NUM from  A_SERVICE_CATEGORY
  where CATEGORY_DESCRIPTION = "routine engine maintenance");
+---------+------------+----------+-----------+-------------+-----------+-----------+------------+
| SLIP_ID | MARINA_NUM | SLIP_NUM | EST_HOURS | SPENT_HOURS | OWNER_NUM | LAST_NAME | FIRST_NAME |
+---------+------------+----------+-----------+-------------+-----------+-----------+------------+
|       4 | 1          | B1       |      1.00 |        0.00 | JU92      | Juarez    | Maria      |
+---------+------------+----------+-----------+-------------+-----------+-----------+------------+
1 row in set (0.00 sec)

MariaDB [textbook]> notee;