This repository contains SQL scripts for managing and analyzing a Bikesales database. The scripts are designed to perform various operations related to products, customers, orders, and sales analytics. Database Structure The database consists of several key tables, including:

customers: Contains customer details. orders: Stores order information linked to customers. order_items: Details of products ordered, including quantities and discounts. products: Information about the products available for sale. brands: Details about product brands. categories: Product categorization. staffs: Information about staff members handling orders. stocks: Inventory data for stores. stores: Details of store locations.