Lab 2 &3

(1) Exercise #1


mysql> select item from items_ordered where customerid='10449';
+--------------+
| item         |
+--------------+
| Unicycle     |
| Snow Shoes   |
| Bicycle       |
| Canoe         |
| Flashlight   |
| Canoe Paddle |
+--------------+
(2) Exercise #2

mysql> select * from items_ordered where item='tent';
+------------+------------+------+----------+-------+
| customerid | order_date | item | quantity | price |
+------------+------------+------+----------+-------+
| 10439       | 1999-09-18 | Tent |         1 |     88 |
| 10438       | 2000-01-18 | Tent |         1 | 79.99 |
+------------+------------+------+----------+-------+
(3) Exercise #3

mysql> select customerid,order_date,price from items_ordered where item LIKE 's%
';
+------------+------------+-------+
| customerid | order_date | price |
+------------+------------+-------+
| 10298       | 1999-07-01 |     33 |
| 10439       | 1999-08-14 |   25.5 |
| 10449       | 1999-09-01 |     45 |
| 10410       | 1999-10-28 | 89.22 |
| 10101       | 2000-03-08 |   88.7 |
| 10330       | 2000-04-19 | 16.75 |
+------------+------------+-------+












(4) Exercise #4

mysql> select distinct item from items_ordered;
+---------------------+
| item                 |
+---------------------+
| Pogo stick           |
| Raft                 |
| Skateboard           |
| Life Vest           |
| Parachute           |
| Umbrella             |
| Unicycle             |
| Ski Poles           |
| Rain Coat           |
| Snow Shoes           |
| Tent                 |
| Lantem               |
| Sleeping Bag         |
| Pillow               |
| Helmet               |
| Bicycle             |
| Canoe               |
| Hoola Hoop           |
| Flashlight           |
| Inflatable Mattress |
| Lawnchair           |
| Compass             |
| Pocket Knife         |
| Canoe Paddle         |
| Ear Muffs           |
| Shovel               |
+---------------------+
Aggregate...