Topic: "common-table-expression"
MGeurts/genealogy
Genealogy is a free and open-source family tree PHP application to record family members and their relationships, build with LARAVEL 12.
Language: PHP - Size: 30.6 MB - Last synced at: 2 days ago - Pushed at: 2 days ago - Stars: 237 - Forks: 77
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.
Language: Python - Size: 139 KB - Last synced at: 8 days ago - Pushed at: 3 months ago - Stars: 44 - Forks: 5
somnambulist-tech/cte-builder
Common Table Expression builder that uses Doctrine DBAL
Language: PHP - Size: 62.5 KB - Last synced at: about 4 hours ago - Pushed at: over 1 year ago - Stars: 22 - Forks: 2
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.
Language: TypeScript - Size: 93.8 KB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 2 - Forks: 0
franckbinde/dannys_diner
SQL Challenge
Size: 69.3 KB - Last synced at: 3 months ago - Pushed at: almost 3 years ago - Stars: 2 - Forks: 0
duttarajat/Wise-Owl-SQL-Server-Exercises-Solutions
Wise Owl SQL Server Exercises Solutions
Language: TSQL - Size: 707 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 1 - Forks: 0
HermawanHermawan/Optimizing-Retail-Revenue-in-SQL
Analyze product data for an online sports retail company to optimize revenue.
Language: Jupyter Notebook - Size: 14.6 KB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 1 - Forks: 0
Costopoulos/RealTime-Transport-Statistics
Real-time transport statistics application using data from Helsinki's Transportation Service API's MQTT broker
Language: TypeScript - Size: 16.1 MB - Last synced at: 1 day ago - Pushed at: 1 day ago - Stars: 0 - Forks: 0
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 💡
Language: PLSQL - Size: 12 MB - Last synced at: 3 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0
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.
Size: 64.4 MB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0
hallsptcd/Advanced-SQL-Server
A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.
Size: 34.2 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0
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.
Size: 13.1 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0
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).
Size: 159 KB - Last synced at: about 1 year ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0
InterruptSpeed/telemetry-sql-kungfu
This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.
Size: 5.86 KB - Last synced at: 2 days ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 1
28101991SUNNY/RDBMS-and-SQL-
my learnings and practice with SQL functions
Language: Jupyter Notebook - Size: 6.86 MB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0
ejw-data/proj-gradebook
Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.
Language: Jupyter Notebook - Size: 1.32 MB - Last synced at: 3 months ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0
ejw-data/etl-election-reporting
Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.
Language: Jupyter Notebook - Size: 2 MB - Last synced at: 3 months ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0
flapjackstan/database-code_snippets
example sql queries
Size: 6.76 MB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0
AfonsoFeliciano/Views-and-CTEs-on-Databricks
Repositório do módulo de Databases, Tables and Views on Databricks do curso Data Analyst Learning Plan
Language: HTML - Size: 189 KB - Last synced at: over 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0
