GlobalMart is a leading retailer in the fast-moving consumer goods (FMCG) sector, offering a wide range of products, including the popular detergent brand, Tide However, Tide faces increasing competition from rival brands, particularly Nirma and Surf Excel, who have adopted aggressive pricing strategies. This has led to fluctuating customer demand and inefficient inventory management. To address these challenges, the company seeks to optimize Tide’s sales by analyzing historical competitor pricing, customer behavior, and inventory levels. The goal is to understand how pricing fluctuations and customer engagement metrics impact sales performance and inventory optimization. As part of the Data Intelligence Team, your task is to write SQL queries to help GlobalMart make data-driven decisions that optimize sales performance, improve inventory management, and reduce inefficiencies.