Skip to content
/ SQL_Invoicing_DB Public

*SQL* queries that I wrote to extract, modify and analyze data off of the 'Invoices Database'

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

Naarestan/SQL_Invoicing_DB

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

53 Commits
Paid_more_than_$100_in_VA_State.sql
Paid_more_than_$100_in_VA_State.sql
 
 
Paid_more_than_$100_in_VA_State.sql.csv
Paid_more_than_$100_in_VA_State.sql.csv
 
 
README.md
README.md
 
 
Summery_Of_Invoices_Dataset_2019.sql
Summery_Of_Invoices_Dataset_2019.sql
 
 
Summery_Of_Invoices_Dataset_2019.xml.csv
Summery_Of_Invoices_Dataset_2019.xml.csv
 
 
Total_Amount_By_Payment_Method.csv
Total_Amount_By_Payment_Method.csv
 
 
Total_Amount_By_Payment_Method.sql
Total_Amount_By_Payment_Method.sql
 
 
Total_Payments_By_Payment_Method_2019.csv
Total_Payments_By_Payment_Method_2019.csv
 
 
Total_Payments_By_Payment_Method_2019.sql
Total_Payments_By_Payment_Method_2019.sql
 
 
sql.png
sql.png
 
 

Repository files navigation

SQL Invoicing & Store Databases

Objective: To write SQL queries to create tables out of 'invoicing' dataset, mostly for year 2019.

We summerized data using:

                    - Aggregate Functions
                    - GROUP BY Clauses
                    - HAVING Clauses
                    - ROLLUP Operator

SQL Icon

About

*SQL* queries that I wrote to extract, modify and analyze data off of the 'Invoices Database'

Topics

sql invoices database-management sqlquery sqlquestions

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published