+-----------------+ | Tables_in_paulp | +-----------------+ | customers | | orderlines | | orders | | salesreps | +-----------------+ 4 rows in set (0.00 sec) mysql> select * from customers; +-----+-----------+------------+---------+--------------+-----------+ | id | last_name | first_name | balance | credit_limit | sales_rep | +-----+-----------+------------+---------+--------------+-----------+ | 124 | Adams | Sally | 818.75 | 1000 | 03 | | 256 | Samuels | Ann | 21.5 | 1500 | 06 | | 311 | Charels | Don | 825.75 | 1000 | 12 | | 315 | Daniels | Tom | 770.75 | 750 | 06 | | 405 | Williams | Al | 402.75 | 1500 | 12 | | 412 | Adams | Sally | 1817.5 | 2000 | 03 | | 522 | Nelson | Mary | 98.75 | 1500 | 12 | | 567 | Dinh | Tran | 402.4 | 750 | 00 | | 587 | Galvez | Mara | 114.6 | 1000 | 06 | | 622 | Martin | Dan | 1045.75 | 1000 | 03 | +-----+-----------+------------+---------+--------------+-----------+ 10 rows in set (0.00 sec) mysql> select * from orderlines; +-------+------+----------+--------+ | id | part | quantity | price | +-------+------+----------+--------+ | 12498 | AZ52 | 2 | 12.95 | | 12475 | BT04 | 10 | 230 | | 12475 | AX45 | 100 | 0.99 | | 12475 | RT56 | 2 | 12.5 | | 12475 | AZ09 | 50 | 1.95 | | 12475 | DF56 | 2 | 12.95 | | 12476 | ER45 | 50 | 2.95 | | 12476 | WE40 | 5 | 4.5 | | 12476 | WE30 | 1 | 19.9 | | 12477 | AZ52 | 1 | 12.95 | | 12478 | QW34 | 20 | 2.95 | | 12478 | RT50 | 12 | 4 | | 12478 | GH78 | 5 | 0.95 | | 12478 | ER45 | 1 | 12.95 | | 12478 | SD10 | 10 | 3.95 | | 12482 | AZ52 | 4 | 12.95 | | 12482 | BT20 | 100 | 4.95 | | 12482 | QW34 | 30 | 3 | | 12483 | DS29 | 25 | 6.95 | | 12483 | WE40 | 1 | 230 | | 12483 | GH56 | 20 | 12 | | 12483 | DG40 | 1 | 9.95 | | 12483 | TY50 | 100 | 0.99 | | 12484 | DX00 | 4 | 99.95 | | 12487 | RA50 | 4 | 9.95 | | 12487 | BT20 | 30 | 5.95 | | 12487 | RT56 | 100 | 0.99 | | 12487 | TY78 | 50 | 1.95 | | 12489 | AX12 | 11 | 14.95 | | 12504 | BT04 | 1 | 250 | | 12494 | CB03 | 4 | 279.99 | | 12495 | CZ81 | 2 | 22.95 | | 12498 | BT04 | 4 | 250 | | 12498 | AX12 | 2 | 12.95 | +-------+------+----------+--------+ 34 rows in set (0.02 sec) mysql> select * from orders; +-------+------------+-------------+ | id | order_date | customer_ID | +-------+------------+-------------+ | 12475 | 2008-09-01 | 522 | | 12476 | 2008-09-01 | 311 | | 12477 | 2008-09-01 | 567 | | 12478 | 2008-09-01 | 587 | | 12482 | 2008-09-01 | 124 | | 12483 | 2008-09-01 | 315 | | 12484 | 2008-09-02 | 256 | | 12489 | 2008-09-02 | 311 | | 12494 | 2008-09-04 | 315 | | 12495 | 2008-09-04 | 256 | | 12498 | 2008-09-05 | 522 | | 12504 | 2008-09-06 | 522 | +-------+------------+-------------+ 12 rows in set (0.02 sec) mysql> select * from salesreps; +----+-----------+------------+------------+------+ | id | last_name | first_name | commission | rate | +----+-----------+------------+------------+------+ | 03 | Jones | Mary | 2150 | 0.05 | | 06 | Smith | William | 4912.5 | 0.07 | | 12 | Diaz | Miguel | 2150 | 0.05 | +----+-----------+------------+------------+------+ 3 rows in set (0.01 sec)