Superstore Sales Analysis This repository contains SQL scripts designed for analyzing sales data from a hypothetical Superstore. The scripts cover various aspects of the dataset, including customer demographics, sales performance by category, payment methods, and more.
Overview The SQL scripts are organized to perform the following tasks:
Database Creation: Initial setup for the Superstore database. Customer Demographics: Analyzing customer gender and age distribution. Sales Metrics: Calculating total sales, quantity ordered by category, and sales performance by shopping mall. Payment Methods: Counting the usage of different payment methods. Aggregate Functions: Using SQL aggregate functions to summarize sales data. Data Handling: Filling in null values in the age column and categorizing customers based on age brackets.