Skip to content

Instantly share code, notes, and snippets.

@jhyland87

jhyland87/employees_customers_sales.txt

Created May 22, 2017 19:53
Show Gist options
  • Save jhyland87/1fa7dc84ee2f00592d4db4124502f499 to your computer and use it in GitHub Desktop.
Save jhyland87/1fa7dc84ee2f00592d4db4124502f499 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
employees_customers_sales.txt
mysql> select * from employees;
+-------------+------------+----------------+--------+------------+------------+------------------+
| employee_id | first_name | last_name | salary | join_date | department | status |
+-------------+------------+----------------+--------+------------+------------+------------------+
| 1001 | Clark | Kent | 700000 | 2017-01-05 | Banking | Employeed |
| 1002 | Peter | Parker | 800000 | 2016-11-04 | Insurance | Leave of Absence |
| 1003 | Adam | Mann | 65000 | 2017-01-12 | Banking | Employeed |
| 1004 | Sean | Cassidy | 85000 | 2017-04-06 | Insurance | Leave of Absence |
| 1005 | Jason | Blood | 65000 | 2017-03-07 | NULL | Employeed |
| 1006 | Bruce | Wayne | 82000 | 2017-03-09 | Insurance | Leave of Absence |
| 1007 | Susan | Kent-Barr | 65000 | 2017-05-16 | Insurance | Employeed |
| 1008 | Karen | Beecher-Duncan | 100000 | 2001-05-21 | Banking | Employeed |
| 1009 | Daniel | Eaton | 60000 | 2010-09-10 | NULL | Terminated |
| 1010 | Keith | Spencer | 102000 | 2017-10-01 | NULL | Employeed |
+-------------+------------+----------------+--------+------------+------------+------------------+
10 rows in set (0.00 sec)
mysql> select * from customers;
+-------------+-------------+------------+------------+------------------+-------+------------+
| customer_id | employee_id | first_name | last_name | city | state | status |
+-------------+-------------+------------+------------+------------------+-------+------------+
| 1003 | 1002 | James | Hyneman | San Diego | CA | Active |
| 1004 | 1003 | Amanda | Hodges | Phoenix | AZ | Active |
| 1005 | 1002 | James | Bond | Phoenix | AZ | Active |
| 1006 | 1007 | Jim | Lauren-May | Colorado Springs | CO | Inactive |
| 1007 | 1005 | Harvey | Specter | Colorado Springs | CO | Active |
| 1008 | 1010 | Jack | Ryder | New York | NY | Inactive |
| 1009 | 1004 | Scott | Summers | Dallas | TX | Active |
| 1010 | 1006 | Slade | Wikson | Dallas | TX | Active |
| 1011 | 1009 | Sam | !@$ | Phoenix | AZ | Unverified |
| 1012 | 1008 | Darrell | Dane | New York | NY | Inactive |
| 1013 | 1003 | Bette | Kane | San Diego | CA | Active |
| 1014 | 1004 | John | D0e | Phoenix | AZ | Unverified |
+-------------+-------------+------------+------------+------------------+-------+------------+
12 rows in set (0.00 sec)
mysql> select * from sales;
+---------+-------------+-------------+--------+-----------+---------------------+---------------------+-------+
| sale_id | employee_id | customer_id | amount | status | created | updated | order |
+---------+-------------+-------------+--------+-----------+---------------------+---------------------+-------+
| 2004 | 1010 | 1008 | 10100 | Completed | 2017-03-02 00:00:00 | 2017-05-22 12:51:17 | 5 |
| 2006 | 1009 | 1006 | 20900 | Opened | 2017-05-22 12:36:15 | 2017-05-22 12:51:15 | 3 |
| 2007 | 1002 | 1003 | 100000 | Completed | 2017-05-22 12:45:56 | 2017-05-22 12:51:15 | 1 |
| 2009 | 1002 | 1005 | 6000 | Opened | 2017-05-22 12:46:20 | 2017-05-22 12:51:19 | 3 |
| 2010 | 1003 | 1013 | 5000 | Cancelled | 2017-05-22 12:46:47 | 2017-05-22 12:51:23 | 6 |
| 2011 | 1007 | 1006 | 1000 | Completed | 2017-05-22 12:47:15 | 2017-05-22 12:51:18 | 2 |
| 2012 | 1010 | 1008 | 6000 | Opened | 2017-05-22 12:47:31 | 2017-05-22 12:51:25 | 9 |
+---------+-------------+-------------+--------+-----------+---------------------+---------------------+-------+
7 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment