GitHub topics: subqueries

Repositories

RubenGavidia/Databases_mysql_sql-server_PostgreSQL.SQL_Portfolio_RubenGavidia0x

This is my last work done and best projects do it with SQL Databases this repo involves MySQL, SQL Server, PostgreSQL and Microsoft Access.

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

jatomsplamkakj/MySQL-Bootcamp-Go-from-SQL-Beginner-to-Expert

Repo containing materials from MySQL Bootcamp

Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Subash-d/Shiv-restaurant

Analyze a restaurant's new menu performance using MySQL. Explore `menu_items` and `order_details` tables to identify popular items, customer preferences, and revenue insights. Includes SQL queries, database schema, and sample data.

Size: 118 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

hasanzeynal/SQLQueryHub

SQLQueryHub is a comprehensive collection of SQL queries covering various skill levels and topics. From beginners to advanced users, this repository offers a wide range of queries to help you master SQL concepts and enhance your database querying skills.

Size: 31.3 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

EdoChiari/Amazon_Sales_Analysis-Project

Advanced SQL project analyzing over 20,000 sales records from an Amazon-like e-commerce platform. Focuses on customer behavior, product performance, and sales trends using PostgreSQL. Includes data cleaning, revenue analysis, inventory management, and an ERD diagram to visualize database schema.

Size: 1.09 MB - Last synced at: 22 days ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

manuseiro/sql-cheat-sheet

O SQL Basics Cheat Sheet fornece a sintaxe de todas as cláusulas básicas, e mostra como escrever condições diferentes seguido com exemplos.

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

BernhardSchlegel/SQL-dumper

Dumps the result of SQL to an CSV on the filesystem. Queries can be split into subqueries, reducing the complexity on the server side.

Language: Java - Size: 6.41 MB - Last synced at: 6 days ago - Pushed at: almost 3 years ago - Stars: 6 - Forks: 6

Pratt2321/SQL-50

SQL 50 Solutions

Size: 16.6 KB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

dpgitaccount/SQL-Interview-Questions

A comprehensive repository of SQL interview questions covering basic to advanced topics, including queries on joins, aggregations, subqueries, and performance optimization. Ideal for interview preparation and skill enhancement.

Size: 29.3 KB - Last synced at: 3 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

PratikRameshMajage/MYSQL

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

ndomah/MySQL-Bootcamp-Go-from-SQL-Beginner-to-Expert

Repo containing materials from MySQL Bootcamp

Size: 586 KB - Last synced at: 3 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

Ankush-Santra/SQL_Projects

This repository showcases a curated collection of my SQL projects, demonstrating skills from foundational concepts like SELECT, INSERT, and ALTER to advanced techniques such as CTEs and Window Functions.

Size: 3.89 MB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

Syed-Amjad-Ali/Restaurant-Sales-SQL-Project

This was a simple SQL project where I analyzed restaurant sales data, showcasing skills in data creation and querying. The project explores menu performance, order trends, and customer insights.

Language: SQL - Size: 200 KB - Last synced at: 3 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

bradleytkay/sql-practice-1-online-shopping

First practice post-LaunchCode graduation to review the various SQL skills we learned throughout the course.

Language: Jupyter Notebook - Size: 1.77 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

simrandubey218/Employee-Data-Management-Sytem

An employee database where I applied multiple SQL queries during my learning phase. It is a detailed database which includes usage of multiple constraints, well defined relationships and DDL, DML and TCL queries.

Size: 169 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

codewithjaspreet/Sql

Advanced SQL - Discover sequential, step-by-step explanations and solutions, accompanied by the necessary database creation codes, available on Ankit Bansal Sir's YouTube channel for SQL. Give it a ⭐ and stay tuned for more updates!

Size: 146 KB - Last synced at: 2 months ago - Pushed at: almost 2 years ago - Stars: 22 - Forks: 3

vikas98SSS/pizzahut_sales--sql

Hello, my Name is vikas i've created a project in sql

Size: 0 Bytes - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

Shitalwaghmare183/E-commerce-database

This repository contains a comprehensive database solution for an e-commerce platform, featuring key data categories . It includes various SQL queries for data retrieval and analysis, along with a downloadable dataset for exploration. Perfect for understanding e-commerce operations and enhancing database skills.

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

arunkumarsp-ds/Analysis-of-Drop-in-Yammer-s-user-Engagement-using-PostgreSQL

Size: 1.55 MB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

pruthviiraj/Airport-Geospatial-Analysis

Analyzing a Geospatial Airport Database using PostgreSQL and PostGIS

Size: 14.7 MB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

sujith014/leetcode-sql-solutions

Size: 99.6 KB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

sondosaabed/Introduction-to-SQL

Course with udacity that cover SQL for data Scientists, this is my solution for the lessons and the project

Language: SQL - Size: 245 KB - Last synced at: 4 months ago - Pushed at: 12 months ago - Stars: 7 - Forks: 0

DevBigBoy/MYSQL-CRASH-COURSE

The book introduces you to the basics of MySQL development. MySQL development techniques are explained with an emphasis on using Structured Query Language (SQL). Learn to use and create MySQL databases, tables, functions, procedures, views, and triggers

Size: 28.3 KB - Last synced at: about 1 month ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

dBalag/Chinook

The Chinook Data Analysis Project leverages PostgreSQL, Python, and Google Spreadsheets to explore and analyze the Chinook music store database. Insights will be presented through Tableau Dashboards and Stories. Stay tuned for updates as the project evolves.

Language: Jupyter Notebook - Size: 8.09 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 1

ianubhavsisodia/Netflix_Analysis_SQL

Netflix Originals Data Analysis: Exploring Trends and Insights

Size: 21.5 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

leansandoval/BaseDeDatos

Ejercicios resueltos de la materia Base de Datos (2009).

Language: TSQL - Size: 2.58 MB - Last synced at: 16 days ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

Keerthiga-Sekar/Online-retail-Orders-Analysis

This project is based on the order management functionality of an online retail store in which you are provided with the “orders” database and you are asked some queries related to it. Answers to these queries will help the company in making data-driven decisions that will impact the overall growth of the online retail store.

Size: 5.86 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

PHIMAS/Nigeriabanks

This repository contains SQL scripts for transaction analysis and customer insights. It includes scripts for data management, transformation, and optimization within MySQL Workbench. Documentation is provided to ensure clarity and maintainability of SQL queries for analyzing transactional data.

Size: 12.7 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

SampathVSS/DataAnalysis-IPL-Datasets-2008-to-2017-MySQL

Analysis was executed using MySQL on the IPL granular datasets which was available for the period 2008 to 2017

Size: 24.4 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

kpratikin/Hotel-Reservation-System-Database-

Designed and implemented database schema for hotel reservation system. Identified key business metrics for the system and constructed complex SQL queries to retrieve desired information. Documented the entire system by developing comprehensive UML diagrams.

Size: 744 KB - Last synced at: 9 months ago - Pushed at: about 6 years ago - Stars: 11 - Forks: 5

Akriti8813/Movie-Database

The Movie Database project aims to comprehensively catalog information about movies, directors, actors, genres, and user ratings. It exemplifies the application of SQL in developing and managing a relational database, highlighting expertise in advanced queries, subqueries, and data integrity maintenance.

Size: 1.95 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Mohamed-Sharik/SQL-PROJECT

Developed comprehensive SQL projects focused on database design, complex queries, stored procedures, triggers, and performance optimization.

Size: 6.84 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Aichatolba/World-Happiness-Report

Analyzing world happiness data using SQL and R

Language: Jupyter Notebook - Size: 1.72 MB - Last synced at: about 1 year ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

PoojaJukanti/SQL-Project

This SQL project employed COUNT, SUM, AVG, GROUP BY, HAVING, ORDER BY, LIMIT, RANK(), and LIKE for aggregations, analyses, and filtering. It offers a concise overview of India's demographic trends, showcasing SQL's versatility for data exploration.

Size: 0 Bytes - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

HardiPalan/Instagram_user_analytics

Creation of Clone database of instagram and performing Exploratory data analysis using SQL.

Size: 792 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

eosobande/pdo-database-class

A php class for using pdo class for your database queries

Language: PHP - Size: 32.2 KB - Last synced at: over 1 year ago - Pushed at: about 8 years ago - Stars: 4 - Forks: 1

maithilid12/Analyzing_Paper_Company_Database

Used Postgres SQL to analyze Parch and Posey Paper Company data

Language: TSQL - Size: 489 KB - Last synced at: over 1 year ago - Pushed at: almost 5 years ago - Stars: 0 - Forks: 0

MuskanKhandelia/Famous_Paintings_Data_Analysis

data-analysis-sql

Language: Jupyter Notebook - Size: 6.45 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

MDrica1/SQL

SQL Projects and exercises

Size: 1.31 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Wesalabdulghani/SQL-Lab-Exercises---1-Data-Engineering-Bootcamp

This repository contains SQL exercises for the weCloud Data Engineering Bootcamp, aimed at sharpening data querying skills with a focus on retail database scenarios.

Size: 25.4 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Rishi-Solanki07/SQL_Data_Extraction_Project

We Have Huge Data-Base In S.Q.L, Our Task is to Extract Some Data For Company(Advantureworks) and Present that data With our Presentation Skills, For more info Please Visit Read.me File

Size: 4.39 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

NadiaOrdonez/SQL_Tableau_onlineFilm_launch_strategy

Using PostgreSQL and Tableau for an online launch strategy of the film company Rockbuster Stealth LLC

Size: 1.69 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

sukhpreet1910/SQL_basicMediumQueries

SQL_Assignment_3 for coding temple bootcamp

Size: 1000 Bytes - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Pwavodi/Deforestation-SQL-Project

Deforestation SQL Project

Size: 189 KB - Last synced at: over 1 year ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

Manikantanaidu1729/Atliq-Hardware-Ad-Hoc-Insight

This project is done as part of Codebasics Data Analyst Bootcamp

Size: 1.2 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

priyarandivep/SQLProjects

This 2011 census SQL project employed COUNT, SUM, AVG, GROUP BY, HAVING, ORDER BY, LIMIT, RANK(), and LIKE for aggregations, analyses, and filtering. It offers a concise overview of India's demographic trends, showcasing SQL's versatility for data exploration.

Size: 21.5 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

VaibhaviVibhute/SQL-Assignments

The Assignments which I have solved during my education.These includes sql queries on topics like subqueries, Joins & its types, Operators, Statements, Clauses and many more….

Size: 0 Bytes - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

deva-246/Solving-Business-Queries-of-AdventureWorks-Database

Size: 29.3 KB - Last synced at: 23 days ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

deva-246/Solving-Business-Queries-using-PostgreSQL-on-DVD-Rental-Database

Size: 44.9 KB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

diegoecasas/Top-Video-Games

In this project, we'll explore the top 400 best-selling video games created between 1977 and 2020. We'll compare a dataset on game sales with critic and user reviews to determine whether or not video games have improved as the gaming market has grown.

Size: 19.5 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

hakandereli/Sql_Notes

in this project: sample queries were written with Oracle 19c installation. It consists of sample scenarios and notes I took to understand SQL and Oracle architecture.

Language: PLSQL - Size: 6.66 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

mariannapalaia/sql_queries

My SQL Playground Repository: A showcase of my SQL skills. This project features a well-structured database for managing employee, coffee shop, location, and supplier data. Explore it to see my database design expertise in action."

Size: 83 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

leotheanalyst-pdx/SQL_Rockbuster_CF

Data Analytics project for Career Foundry. Analysis of Rockbuster Stealth's online movie rental database to provide insights for a 2020 company launch strategy.

Size: 3.55 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

hamzashehzad09/Advanced-Data-Analytics-on-Shipment-Data

Classification Analysis, Margin Development Analysis, Deviation Analysis, Advanced Sub-Queries and Use of Windows Functions

Language: TSQL - Size: 24.4 KB - Last synced at: over 1 year ago - Pushed at: almost 5 years ago - Stars: 0 - Forks: 0

Aichatolba/Northwind-Database-Analysis

Analyzing product data using SQL

Language: Jupyter Notebook - Size: 1.65 MB - Last synced at: about 1 year ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

todor-petrov/MS-SQL-Server

MS SQL Server

Language: TSQL - Size: 97.7 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

DSKunth/Deforestation-Exploration

Create views, simple and complex SQL queries to answer questions from the fictitious ForestQuery management about the deforestation’s global situation, regional outlook, and country-level details

Size: 889 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

Syed-Sarfaraz-Ahmed/IG_CLONE

Creation of Clone database of instagram and performing Exploratory data analysis using SQL.

Size: 2.05 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

atiley/SQL-Portfolio

Quick examples of SQL using Sakila data

Size: 799 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

praveen-kumar-maurya/Bank-Customer-Churn

The objective of bank customer churn analysis in PostgreSQL is to identify patterns and predictors of churn, enabling the implementation of personalized retention strategies. By improving customer retention and fostering long-term relationships, the bank aims to enhance profitability and gain a competitive advantage.

Size: 1.02 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

ashleyj2/DA102-SQL-queries

Notes from refreshing SQL knowledge

Size: 89.8 KB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 0

dheepika-chokkalingam/Online-Video-Streaming-Analysis-Using-SQL

Answers to complex business questions posed by fictitious online video streaming company's management board using SQL.

Size: 3 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

shivanidashore777/FAASOS_SQL_ANALYSIS_PROJECT

Faasos (now Rebel Foods) is a popular Indian food delivery company. It started as a restaurant chain, then shifted online. They offer affordable meals, diverse cuisines, and efficient delivery. Rebel Foods operates multiple brands, using technology to enhance the food delivery experience.

Size: 634 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 2 - Forks: 0

MaxLopezSalgado/sql-playground

This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, that allow to apply basic, intermediate and advance SQL queries to different datasets.

Size: 46.9 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 1 - Forks: 0

tweichle/Mode-SQL-Tutorial

Learn to answer questions with data using SQL

Language: PLpgSQL - Size: 21.5 KB - Last synced at: about 2 years ago - Pushed at: about 6 years ago - Stars: 1 - Forks: 4

tweichle/w3resource-SQL-Exercises

Exercises to help improve SQL skills

Size: 81.1 KB - Last synced at: about 2 years ago - Pushed at: almost 6 years ago - Stars: 28 - Forks: 69

lfideo/calculate-pageviews

A small project where I demonstrate how to write a SQL query to calculate values within specific time windows.

Size: 1000 Bytes - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

Peter-Lazarov/MS-SQL-Database-Homeworks-at-SoftUni

January 2019 I have time and will to pass course for database. This is course for Microsoft SQL Database at SoftUni.

Language: TSQL - Size: 24.4 KB - Last synced at: about 1 year ago - Pushed at: about 3 years ago - Stars: 0 - Forks: 0

martacanirome4/java-mysql

Connection and quering to MySQL Sakila and World databases via Java app

Language: Java - Size: 18.6 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

tomarshabh2199/Advanced-Sql-Interview-Questions

Advanced Sql Interview Questions that covers topics like CTE, Analytics Window Functions, Aggregation Functions, Subqueries these topics will help you to boost your interview questions

Language: C++ - Size: 13.7 KB - Last synced at: about 1 year ago - Pushed at: over 2 years ago - Stars: 2 - Forks: 0

Nargis45/SQL_youtube

I have started a new playlist called MySQL on my YouTube channel. Watch the videos to learn SQL from scratch.

Size: 28.3 KB - Last synced at: about 2 years ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 0

yunuserbas/SqlQueries

All the SQL queries repository with examples from the first steps to advanced queries.

Language: PLpgSQL - Size: 69.3 KB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 2 - Forks: 3

Sampath-Vinayakh/Superstore-Data-Analysis

Worked on a superstore dataset to help potential superstore owners make data driven decisions

Size: 6.48 MB - Last synced at: about 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

eddahbarasa/DatabaseStructuresAndManagementWithMySQL

DBMS skills such as data creation, joins, grouping, constraints, subqueries, views, functions and simple procedures

Size: 51.8 KB - Last synced at: 6 months ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

kristian9577/Database-Basics-MySQL

SoftUni - Database-Basics-MySQL

Language: TSQL - Size: 130 KB - Last synced at: over 2 years ago - Pushed at: almost 6 years ago - Stars: 2 - Forks: 1

eddahbarasa/AdvancedMySQL

Pushing beyond simple SQL statements in MySQL to an advanced level dealing with complex stored procedures and functions, using variables and parameters, creating triggers and events, using CTEs, prepared statements, using the JSON data type. emulating full outer join.

Size: 68.4 KB - Last synced at: 6 months ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

subqueries 91 sql 54 joins 50 mysql 20 cte 18 database 18 postgresql 17 data-analysis 12 functions 11 aggregation 9 queries 9 window-functions 8 triggers 8 views 8 aggregations 7 relational-databases 6 mysql-database 6 aggregate-functions 6 stored-procedures 5 sql-server 5 constraints 4 trigger 4 datatypes 4 data-modeling 4 sql-query 4 data-visualization 3 builtin-functions 3 table 3 sql-joins 3 aggregate-function 3 transactions 3 dml 3 ddl 3 excel 3 order-by 3 crud 3 join 3 grouping 3 windowfunctions 3 query 3 dml-commands 3 groupby 3 normalization 2 date-time 2 stored-procedure 2 sql-server-management-studio 2 sql-functions 2 tableau-dashboard 2 python 2 database-programmability 2 mysql8 2 performance-tuning 2 data-science 2 sql-syntax 2 aggregates 2 windowfunction 2 stored-routines 2 eda 2 relational 2 querying 2 procedures 2 data-analytics 2 temporary-tables 2 cleaning-data 2 pivot-tables 2 regex 2 oracle-database 2 tableau 2 powerpoint-presentations 2 exploratory-data-analysis 2 analysis 2 r 2 databases 2 built-in-functions 2 table-relations 2 data 2 windows 2 mysql-workbench 2 trigger-events 2 wildcard-matches 2 tsql 2 filtering-data 2 crud-operations 2 datacleaning 2 ssms 2 having 2 tcl 2 sql-queries 2 dql 2 sorting 2 group-by 2 clauses 2 ddl-commands 2 pgadmin 2 visualization 1 practice 1 analytics 1 data-aggregation 1 indices 1 microsoft-sqlserver-database 1