Skip to content

susanalista/sql-ecommerce-query

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

SQL e-commerce query

ecommerce_photo

We have a data base from an e-commerce which sells products for health and wellness. The data base was originally a csv file which was converted to db in a previous notebook. Since we are focusing on SQL queries, we don't show the previous code for EDA (Exploratory Data Analysis) and db conversion.

This is a descriptive screenshot for the different columns:

  • created_at : timestamp of when order is created
  • order_number : self-explanatory
  • sku: unique reference for each product
  • total_order_price: self explanatory
  • code: the discount code applied to this order

database

We use SQL query to answer the following questions:

  • How many orders per day?
  • How much sales per day?
  • What is the top selling product?
  • What percentage of orders are with discount codes?
  • What percentage of orders include the product with SKU PM591?
  • Which hour of day do people buy most products?

About

SQL queries for product sales on e-commerce website.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published