GitHub topics: subqueries-and-joins

Repositories

mohamedsalah-coder/Advanced-SQL-Analytics-Project

🔍 Explore raw data through SQL for deep analytics, transforming insights into final reports on customer and product performance.

Language: TSQL - Size: 5.23 MB - Last synced at: 4 days ago - Pushed at: 4 days ago - Stars: 0 - Forks: 0

Wb-az/sql-for-data-analysis-udacity

This repository contains SQL queries for the SQL for Data Analysis given by Udacity. The queries include commands to define, select, manipulate, control access, aggregate, and join data and data tables.

Size: 381 KB - Last synced at: 6 days ago - Pushed at: 6 days ago - Stars: 0 - Forks: 0

pushkarguptaaa/Advanced-SQL-Analytics-Project

An Advanced SQL Analytics Project demonstrating end-to-end data analysis using SQL — from EDA and ADA to data transformations and final business reports. Includes two analytical views summarizing Customer and Product performance with insights on revenue, trends, and growth.

Language: TSQL - Size: 5.22 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

arshadbu15/Indian_census_Analysis

SQL analysis of Indian census data.

Size: 30.3 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

Sajjad-Ali-1411/Bank-Loan-Analysis-SQL-Power-BI-

The objective of this project was to analyze bank loan application data to uncover patterns in customer profiles, loan approvals, and repayment behavior. This helps the bank in decision-making, risk analysis, and customer targeting.

Size: 7.86 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

a7madv4d2/PostgreSQL-and-Power-BI-Project

SQL analysis of Forbes Global 2000 using CTEs, window functions, subqueries and views.

Size: 2.81 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

ameerahrazali/mlb-analysis

A structured SQL analysis of Major League Baseball (MLB) data using analytical queries and window functions.

Size: 42.7 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

OsarohEkhoragbon/SQL-Fraud-Detection-Banking

A SQL-based fraud detection project using PostgreSQL to analyze transaction data for a bank and uncover high-risk behaviors, repeat offenders, and location-based anomalies.

Size: 28.1 MB - Last synced at: 5 months ago - Pushed at: 6 months ago - Stars: 1 - Forks: 0

matheusaugam/Exercicio-SubConsultas

Exercício de criação de uma locadora de carros em MySQL para a inserção de dados e para o uso de pesquisas e sub-pesquisas utilizando os métodos "join", "left join", "where", "from" entre outros..

Size: 3.91 KB - Last synced at: 6 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

Mandeep04Sharma/Pizza-Hut-Sales-Analysis---SQL

This SQL-based project analyzes Pizza Hut's sales data to uncover insights about customer behavior, product performance, and store efficiency. It focuses on optimizing decision-making by leveraging advanced SQL techniques.

Size: 5.52 MB - Last synced at: 29 days ago - Pushed at: 7 months ago - Stars: 1 - Forks: 0

AngEvd/PostgreSQL

Homework solutions for SoftUni PostgreSQL course

Language: PLpgSQL - Size: 897 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

LKEthridge/Data_Collection_and_Storage_-SQL-

A Data Collection and Storage project using SQL from TripleTen

Language: Jupyter Notebook - Size: 162 KB - Last synced at: about 1 month ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

trayanaboykova/MySQL

Tasks from my course MYSQL at SoftUni

Size: 283 KB - Last synced at: 8 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

vinayak-sharma2002/Blood-Bank-Management-SQL-database

This repository has the code for my SQL project where I have created a database in MySQL for a blood bank containing all the necessary information such as the details of the staff such as: Managers, Recording Staff, Disease Finders, etc. Details of Blood Specimens and donors and visits as well. It also has queries that can be used on real data.

Size: 2.93 KB - Last synced at: 6 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

ranvikhalar/sql Fork of UofT-DSI/sql

Language: HTML - Size: 325 MB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

SatvikPraveen/RSVP_Case_Study

A comprehensive IMDB dataset analysis using SQL. Includes database setup, advanced queries, and actionable insights. Organized with files for database creation, queries, and solutions. Features an Entity-Relationship Diagram (ERD), executive summary, and SQL scripts. Perfect for SQL workflows and business intelligence in the film industry.

Size: 3.49 MB - Last synced at: 8 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

sujith014/leetcode-sql-solutions

Size: 99.6 KB - Last synced at: 8 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

AnoshZahir/sql-project-data-job-analysis

SQL queries developed as part of a data analysis project. Includes analysis of job data, queries for insights into job categories, salaries, and customer behavior. Techniques used include JOINS, CTEs, subqueries, and aggregate functions. Inspired by DataNerd's YouTube tutorial: https://www.youtube.com/watch?v=7mz73uXD9DA

Language: PLpgSQL - Size: 19.1 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0