From 6cdd053ccbafe5c479ae379448a85569bccdf19d Mon Sep 17 00:00:00 2001
From: Christian Cleberg <hello@cleberg.net>
Date: Fri, 16 Jun 2023 16:43:28 -0500
Subject: add basic sqlite3 analysis script

---
 projects/sqlite3-analysis/README.md | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 projects/sqlite3-analysis/README.md

(limited to 'projects/sqlite3-analysis/README.md')

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
+```
-- 
cgit v1.2.3-70-g09d2