diff options
| author | Christian Cleberg <hello@cleberg.net> | 2023-06-16 16:43:28 -0500 |
|---|---|---|
| committer | Christian Cleberg <hello@cleberg.net> | 2023-06-16 16:43:28 -0500 |
| commit | 6cdd053ccbafe5c479ae379448a85569bccdf19d (patch) | |
| tree | 65d5e1f9f2da99afd94960a8c9e14c69241a8248 /projects/sqlite3-analysis/README.md | |
| parent | 836841dba83ae4b79009799642a7acdef13ffd48 (diff) | |
| download | data-science-6cdd053ccbafe5c479ae379448a85569bccdf19d.tar.gz data-science-6cdd053ccbafe5c479ae379448a85569bccdf19d.tar.bz2 data-science-6cdd053ccbafe5c479ae379448a85569bccdf19d.zip | |
add basic sqlite3 analysis script
Diffstat (limited to 'projects/sqlite3-analysis/README.md')
| -rw-r--r-- | projects/sqlite3-analysis/README.md | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/projects/sqlite3-analysis/README.md b/projects/sqlite3-analysis/README.md new file mode 100644 index 0000000..18a1a43 --- /dev/null +++ b/projects/sqlite3-analysis/README.md @@ -0,0 +1,26 @@ +## Instructions + +```bash +# Open the database: +sqlite3 ./chinook.db +``` + +```sql +# 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 +``` + +```bash +# Inspect the results +cat ./employee_sales.csv +``` + +```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 +``` |