common-table-expression

There are 23 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 11.

    Language:PHP16961248

  • 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:Python433166

  • somnambulist-tech/cte-builder

    Common Table Expression builder that uses Doctrine DBAL

    Language:PHP20632

  • RyanHarrisonOriginal/cte_explorer

    UI to visualize common table expressions in sql scripts

    Language:Python7202

  • Senja-P/SQL-Customer-Sales

    Examples of SQL queries created for Customer and Sales Data Analysis study project

    6201

  • 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:TypeScript2

  • duttarajat/Wise-Owl-SQL-Server-Exercises-Solutions

    Wise Owl SQL Server Exercises Solutions

    Language:TSQL2201

  • franckbinde/dannys_diner

    SQL Challenge

    2100

  • HermawanHermawan/Optimizing-Retail-Revenue-in-SQL

    Analyze product data for an online sports retail company to optimize revenue.

    Language:Jupyter Notebook2110

  • 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.

    1100

  • 28101991SUNNY/RDBMS-and-SQL-

    my learnings and practice with SQL functions

    Language:Jupyter Notebook0100

  • 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:HTML0100

  • anamm1/TSQL-Project

    TSQL-Project about the management of a plant store

    0100

  • 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:PLSQL0100

  • ejw-data/etl-election-reporting

    Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.

    Language:Jupyter Notebook0100

  • ejw-data/proj-gradebook

    Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.

    Language:Jupyter Notebook0100

  • hallsptcd/Advanced-SQL-Server

    A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.

    0100

  • 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.

    0100

  • 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.

    0100

  • 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).

    0100

  • 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.

    0100

  • Costopoulos/RealTime-Transport-Statistics

    Real-time transport statistics application using data from Helsinki's Transportation Service API's MQTT broker

    Language:TypeScript10

  • InterruptSpeed/telemetry-sql-kungfu

    This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.

    301