SQL_RETAIL_SALES.sql

USE RETAILANALYSIS;

SELECT * FROM RETAIL_WARESALE;

SELECT COUNT(*) FROM RETAIL_WARESALE;
SELECT TOP 10 * FROM RETAIL_WARESALE;


SELECT
	YEAR,
	MONTH,
	SUPPLIER,
	ITEM_CODE,
	ITEM_DESCRIPTION,
	ITEM_TYPE,
	RETAIL_SALES,
	RETAIL_TRANSFERS,
	WAREHOUSE_SALES,
	CASE
		WHEN SUPPLIER IS NULL OR SUPPLIER = '' THEN 'INTERNAL_MOVEMENT'
		ELSE 'EXTERNAL_SUPPLIER'
	END AS SUPPLIER_TYPE
INTO RETAIL_DATA_CLEANED
FROM RETAIL_WARESALE;

SELECT COUNT(*) AS TOTAL_ROWS FROM RETAIL_DATA_CLEANED;
SELECT TOP 10 * FROM RETAIL_DATA_CLEANED;

--- Month-wise Retail Demand

SELECT YEAR, MONTH, SUM(RETAIL_SALES) AS TOTAL_RETAIL_SALES
FROM RETAIL_DATA_CLEANED
WHERE SUPPLIER_TYPE = 'EXTERNAL_SUPPLIER'
GROUP BY YEAR, MONTH
ORDER BY YEAR, MONTH;

--- Supplier performance (TOP SUPPLIERS)

SELECT * FROM RETAIL_DATA_CLEANED;

SELECT SUPPLIER, SUM(RETAIL_SALES) AS TOTAL_RETAIL_SALES
FROM RETAIL_DATA_CLEANED
WHERE SUPPLIER_TYPE = 'EXTERNAL_SUPPLIER'
GROUP BY SUPPLIER
ORDER BY TOTAL_RETAIL_SALES DESC;

--- Inventory return check

SELECT ITEM_TYPE, SUM(WAREHOUSE_SALES) AS NET_WAREHOUSE_MOVEMENT
FROM RETAIL_DATA_CLEANED
GROUP BY ITEM_TYPE;

SELECT * FROM RETAIL_DATA_CLEANED;