common-table-expression
There are 24 repositories under common-table-expression topic.
MGeurts/genealogy
Genealogy is a free and open-source family tree PHP application to record family members and their relationships, build with LARAVEL 12.
OmenApps/django-postgresql-dag
Directed Acyclic Graphs with a variety of methods for both Nodes and Edges, and multiple exports (NetworkX, Pandas, etc). This project is the foundation for a commercial product, so expect regular improvements. PR's and other contributions are welcomed.
somnambulist-tech/cte-builder
Common Table Expression builder that uses Doctrine DBAL
RyanHarrisonOriginal/cte_explorer
UI to visualize common table expressions in sql scripts
Senja-P/SQL-Customer-Sales
Examples of SQL queries created for Customer and Sales Data Analysis study project
CleilsonAndrade/in.orbit-api
in.orbit-api é uma API Rest com o fim de realizar o gerenciamento de metas semanais, permitindo o cadastramento da meta, quantidade de dias que será realizada durante a semana, listagem, exibindo as metas da ultima semana baseando-se no dia atual com a contagem de dias que a meta foi realizada e permitindo a atualização de uma meta como concluída.
duttarajat/Wise-Owl-SQL-Server-Exercises-Solutions
Wise Owl SQL Server Exercises Solutions
franckbinde/dannys_diner
SQL Challenge
HermawanHermawan/Optimizing-Retail-Revenue-in-SQL
Analyze product data for an online sports retail company to optimize revenue.
dBalag/Nike-CTEs
Unlock the power of SQL’s Common Table Expressions (CTEs) to transform data analysis capabilities! In this project, I demonstrate how to leverage CTEs to answer complex business questions with clarity and efficiency. Whether you’re dealing with hierarchical data, simplifying complex queries, or improving readability, CTEs are a game-changer.
joelquartey/retail-sales-sql-project
A SQL-only ETL data infrastructure
28101991SUNNY/RDBMS-and-SQL-
my learnings and practice with SQL functions
AfonsoFeliciano/Views-and-CTEs-on-Databricks
Repositório do módulo de Databases, Tables and Views on Databricks do curso Data Analyst Learning Plan
anamm1/TSQL-Project
TSQL-Project about the management of a plant store
bursasha/oracle-postgresql-projects
Advanced SQL, covering Oracle PL/SQL and PostgreSQL PL/pgSQL with phases on using procedures, functions, triggers, query optimizations, packages, and Docker server setup 💡
ejw-data/etl-election-reporting
Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.
ejw-data/proj-gradebook
Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.
hallsptcd/Advanced-SQL-Server
A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.
jianninapinto/COVID19_Crisis
Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.
Olivia-E-Murphy/Movie-Rental-Analysis-for-Rockbuster-Stealth
Business questions were solved for Rockbuster Stealth LLC, a fictional movie rental company, through the use of SQL in this project. This project was completed as part of the CareerFoundry's curriculum.
renadhamdy/Analytical-SQL
RFM Analysis for customer segemntation, to categorize the customers based on resency, frequency and monetary. by using analytical SQL functions and common table expression(CTE).
Theofilusarifin/Analyzing-eCommerce-Business-Performance-with-SQL
In any company, measuring business performance is crucial for tracking, monitoring, and evaluating the success or failure of various business processes. Therefore, this project aims to analyze the business performance of an eCommerce company, considering several business metrics: customer growth, product quality, and payment types.
Costopoulos/RealTime-Transport-Statistics
Real-time transport statistics application using data from Helsinki's Transportation Service API's MQTT broker
InterruptSpeed/telemetry-sql-kungfu
This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.