Description:

The sql code is about finding those products in the store which are not sold for years and hence we need to not order them in the future.

The data is stored in the database db , the sales data is stored in table tblsale and purchases data is recorded in table tblpurchase.

The two tables for sales and purchases are joined together using full joins, and then only those records were filtered out using a WHERE Clause which were purchased last year (2022) or before last year and they are not sold yet. at the end the the results are sorted using ORDER BY clause in descending order so that we have oldest stock on the top.

Purpose and scope

This kind of analysis help the stakeholders to identify those products in the store which are slow moving and they are not best for business as the customers are reluctant to buy it.