cmc/data-science
Personal data science learning files.
clone: git clone https://gitbay.org/cmc/data-science.git
main: projects/sqlite3-analysis/
| 100644 | README.md | 765 |
| 100644 | chinook.db | 884736 |
| 100644 | db_diagram.png | 267656 |
| 100644 | employee_sales.csv | 425 |
| 100644 | employee_sales.sql | 901 |
Instructions
# Open the database:
sqlite3 ./chinook.db
-- Enable some features and export the CSV results of the script
.headers on
.mode csv
.output /home/cmc/git/data-science/projects/sql-dashboard/employee_sales.csv
.read employee_sales.sql
# Inspect the results
cat ./employee_sales.csv
EmployeeId,LastName,FirstName,Title,CustomerId,SupportRepId,State,Country,InvoiceId,CustomerId,InvoiceDate,InvoiceId,UnitPrice,Quantity,TotalPrice
3,Peacock,Jane,"Sales Support Agent",1,3,SP,Brazil,98,1,"2010-03-11 00:00:00",98,1.99,1,1.99
4,Park,Margaret,"Sales Support Agent",4,4,,Norway,2,4,"2009-01-02 00:00:00",2,0.99,1,0.99
5,Johnson,Steve,"Sales Support Agent",2,5,,Germany,1,2,"2009-01-01 00:00:00",1,0.99,1,0.99