windowfunction

This Repository Contains a collection of SQL Scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, part-to-whole anlaysis.

A similar environment that of various IPL Fantancy Sports App like Dream11 is created and the data is extracted according to questions asked.

SQL Assignment

We analyzed a Walmart sales dataset to gain insights using complex SQL queries.

Data science SQL Skillz(Postgre) - nanodegree udacity. Analyse d'une base de donnée provenant d'une société de location de film vidéo accompagnée d'un rapport visuel .

This SQL Case study was provided by Ankit Bansal on his Youtube channel

This project analyzes historical transaction data from Walmart stores using advanced SQL queries to uncover insights related to sales performance, customer behavior, and operational efficiency. By leveraging SQL techniques, the project covers various aspects such as branch performance, product profitability, customer segmentation, and sales trends.

Advanced SQL Analysis for Cars24 Sales Insights

Music store data analysis using SQL, joins, subqueries, CTEs and window functions

Rebel Foods, formerly known as Faasos, is a renowned food delivery company in India. It originated as a restaurant chain but transitioned into an online platform. Rebel Foods is known for providing affordable meals, a wide variety of cuisines, and prompt delivery services. They operate numerous brands and leverage technology to enhance the overall

These challanges were asked on this webiste.

An end-to-end SQL project on Reliance Finance Sales Analysis using PostgreSQL

Trying my hand at Leetcode Easy,Medium and Hard questions

📊 SQL Projects – Data Analysis Portfolio This repository contains hands-on SQL projects focused on real-world data scenarios. Each project demonstrates practical SQL skills including data cleaning, filtering, joins, aggregations, window functions, CTE usage, views, and business-driven insights.

This project analyzes Namma Yatri ride data using Power BI and a SQL database to identify trends, peak times, and popular routes for data-driven insights.

SQL project analyzing global sales performance, product profitability, and market expansion opportunities for Atliq Hardware.

This repository will contain all leetcode problems and solved solution for SQL starting from beginning to advanced question

This project involved comprehensive exploration and analysis of global COVID-19 data using SQL Server. The dataset included information on COVID-19 cases, deaths, and vaccination rates sourced from publicly available databases (e.g., Our World in Data). The primary objective was to extract meaningful insights from raw pandemic data.

this project to analyze the Online Retail dataset using SQL. The objective of this project was to obtain insights about the data and develop targeted marketing strategies for improving sales and customer loyalty.