An open API service providing repository metadata for many open source software ecosystems.

GitHub topics: window-functions

SergeySenigov/data-engineer-practicum-portfolio

Проекты курса Инженер данных на платформе Yandex Practicum

Language: Python - Size: 6.75 MB - Last synced at: 12 days ago - Pushed at: 12 days ago - Stars: 6 - Forks: 4

VeronSheva/HR_dashboards

Interactive HR dashboard using Tableau & MySQL – explore employee trends, performance, attrition, and salary insights.

Size: 8.56 MB - Last synced at: 14 days ago - Pushed at: 18 days ago - Stars: 0 - Forks: 0

Tharadol07969/sql_sales_analytic

A comprehensive collection of SQL scripts for data exploration, analytics, and reporting.

Language: TSQL - Size: 966 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

rogui-manal/Data-Analysis-with-SQL

This repository contains a comprehensive collection of SQL scripts based on a learning project aimed at practicing data exploration, analytics, and reporting techniques using SQL.

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

NivedhaAk/world-layoffs-sql-project

SQL Data Cleaning and EDA on World Layoffs Dataset using MySQL

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

DataWithBaraa/sql-data-analytics-project

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

Language: TSQL - Size: 20.7 MB - Last synced at: about 2 months ago - Pushed at: 2 months ago - Stars: 40 - Forks: 17

PoojaVishwakarm/SQL-Exploratory-Data-Analysis-EDA-Project-

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

Language: TSQL - Size: 1.42 MB - Last synced at: 2 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

kmdawkins/portfolio-project2

SQL Database Normalization and Advanced Queries

Language: PLpgSQL - Size: 16.1 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

whoisalisha/BOM-Business-Analyst-Technical-Case-Study-Assignment

BOM(Bill of Materials) Business Analyst Case Study Solution using Python, Pandas manipulation and Visualization Technique

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

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

Repo containing materials from MySQL Bootcamp

Size: 586 KB - Last synced at: 2 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: 3 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

egorumaev/2024-colab-sqlite-postgresql

SQL-запросы в Google Colab с помощью SQLite и PostgreSQL

Language: Jupyter Notebook - Size: 473 KB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Prajjwol09/MySQL

The purpose of this repository is to provide a comprehensive guide to MySQL for beginners. It covers the basic concepts and operations involved in using MySQL.

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

muryulia/8-Week-SQL-Challenge

#8WeekSQLChallenge, https://8weeksqlchallenge.com: Solutions for SQL Case Studies

Size: 980 KB - Last synced at: 4 months ago - Pushed at: about 3 years ago - Stars: 41 - Forks: 17

HeatTransfer/7-Wonders

There are seven business-critical questions solved using SQL

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

Gopalkholade/Pizza-Sales-Analysis-with-SQL

Pizza Sales analytics with sql

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

SwethaAshervadam/RSVP_Movies_Assignment

RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2023.

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

victorcezeh/alt-exam-poc Fork of JesuFemi-O/alt-exam-poc

Alt school Fall semester DE exam questions.

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

maithilid12/Analyzing_Paper_Company_Database

Used Postgres SQL to analyze Parch and Posey Paper Company data

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

Jaswin-J/Film-Rental-Analysis

Creating Report for decision making in Film Rental Store

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

ndleah/bitcoin-prices-analysis

💸 Bitcoin trading analysis

Language: SQL - Size: 1.11 MB - Last synced at: about 1 month ago - Pushed at: over 3 years ago - Stars: 7 - Forks: 4

arnavailable/sql

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

MuskanKhandelia/Famous_Paintings_Data_Analysis

data-analysis-sql

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

dmarks84/Ind_Project_Movie-Database-SQLite

Independent Project - I joined and manipulated data from disparate tables of movie information using Python & SQLite; defined schema, created tables/views, queried data, etc. Utilized CTE's, Window Functions, and other DDL, DQL, DML, and DCL scripts.

Language: Python - Size: 2.67 MB - Last synced at: about 2 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 1

Theofilusarifin/E-Commerce-Data-Analysis-with-Elastic-Search

This project involves comprehensive e-commerce data analysis using SQLite and Elasticsearch. It starts by importing the Kaggle E-commerce dataset into SQLite for initial exploration and basic data cleaning. Then, Elasticsearch is employed for indexing and querying, enabling further analysis.

Language: Jupyter Notebook - Size: 7.08 MB - Last synced at: about 1 year ago - Pushed at: over 1 year 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

Gino-Freud-Hobayan/8WeekSQL_Challenge

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

Size: 1.23 MB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 2 - Forks: 0

Chaitanyaprasad60/SQL-Queries

This is a list of complex SQL Queries I have practiced.

Size: 1.46 MB - Last synced at: 3 months 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

tknishh/data-lemur-sql-solution

SQL solutions for DataLemur including all difficult levels.

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

pujaitridas/10dayschallenge

This repository hosts IVY's SQL Internship(July 2023): 10-Days Challenge, which offers participants the opportunity to practice their SQL skills through a series of progressively challenging tasks.

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

Harkirat78/CovidAnalysis-DataExplorationSQL

SQL project that analyzes large amounts of data specifically related to Covid-19 deaths and vaccinations

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

tzelleke/postgres-notes

Personal notes on PostgreSQL

Language: Jupyter Notebook - Size: 563 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - 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: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 1 - Forks: 0

faiyaz106/Query-performance-comparison-in-PostgreSQL

Language: Python - Size: 2.77 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

Rubina-Bansal/SQL-Projects

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

GvHemanth/RSVP_Production_SQL

Giving recommendations to the Top Indian Production team - RSVP ,for their upcoming film about to be released globally.

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

yunusbagriacik/Digital-Filters-in-Audio-Signal-Processing

Digital FIR and IIR filters with intelligible Python codes using SciPy.

Language: Jupyter Notebook - Size: 1.37 MB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 1 - 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

graemebalint/best_hotel_prices_netherlands

A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.

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

ellaclauz/SQL-FOR-DATA-ANALYSIS

SQL projects using the different functions from basic to advance

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

NataliaZvezdina/wib

:page_with_curl: :office: :chart: Test task for WhoIsBlogger (data analyst position) aimed at building complex SQL queries (including window functions)

Language: Python - Size: 7.81 KB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 0 - 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

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

eydelrivero/extension-functions

Extending sqlite extension-functions to support median aggregate function as a window function. See https://www.sqlite.org/contrib. Forked from https://gitlab.com/liamh/extension-functions

Language: C - Size: 46.9 KB - Last synced at: almost 2 years ago - Pushed at: over 5 years ago - Stars: 1 - 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

etfovac/WinAPI

Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL

Language: C# - Size: 27.3 KB - Last synced at: over 2 years ago - Pushed at: over 4 years ago - Stars: 4 - Forks: 0

pablo-ferro/SQL_Advanced_practice

SQL technical cases as interview practice

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

Karan-Pruthi/8-Week-SQL-Challenge

SQL Case Studies Solutions for #8WeekSQLChallenge

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

qbart/workshop-db-03

CTEs and window functions explained for PostgreSQL

Language: Haml - Size: 24.4 KB - Last synced at: 6 days ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

Develop-Packt/Aggregate-and-Window-Functions

This module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.

Language: TSQL - Size: 9.29 MB - Last synced at: over 2 years ago - Pushed at: almost 5 years ago - Stars: 1 - Forks: 3

trajkd/Investigate-a-Relational-Database

Investigate a Relational Database (project 1 of 3 from Udacity Programming for Data Science with Python)

Language: TSQL - Size: 196 KB - Last synced at: over 2 years ago - Pushed at: about 5 years ago - Stars: 0 - Forks: 1