Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM customers;
- +------------+-----------+----------+---------------------------+
- | customerID | firstName | lastName | email |
- +------------+-----------+----------+---------------------------+
- | 1 | Lynn | Parker | lynn.parker@email.com |
- | 2 | Rebecca | Johnson | rebecca.johnson@email.com |
- | 3 | John | Doe | john.doe@email.com |
- +------------+-----------+----------+---------------------------+
- SELECT * FROM products;
- +-----------+---------------------+----------+
- | productID | product | price |
- +-----------+---------------------+----------+
- | 1 | Television | 25000.00 |
- | 2 | Mobile Phone | 20000.00 |
- | 3 | Jacket | 2000.00 |
- | 4 | Samsung Galaxy Tab | 12000.00 |
- | 5 | Think and Grow Rich | 350.00 |
- | 6 | MacBook Air | 65000.00 |
- | 7 | Water Bottle | 150.00 |
- | 8 | Home Theater | 14500.00 |
- | 9 | Microwave | 7658.00 |
- +-----------+---------------------+----------+
- SELECT * FROM orders;
- +---------+------------+-----------+
- | orderID | customerID | productID |
- +---------+------------+-----------+
- | 1 | 1 | 1 |
- | 2 | 1 | 3 |
- | 3 | 1 | 4 |
- | 4 | 2 | 6 |
- | 5 | 2 | 7 |
- | 6 | 2 | 8 |
- | 7 | 2 | 3 |
- | 8 | 2 | 9 |
- | 9 | 2 | 5 |
- +---------+------------+-----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement