Exploratory Data Analysis for European soccer database

Overview

A fun project where I used PostgreSQL to explore the European Soccer Database. I wrote queries to summarize some information and comparisons about all the leagues in the database and provide more in-detail summaries about specific leagues, using some advanced SQL techniques like Window functions and Subqueries.

A real-life application for this would be in any website or application that is interested in presenting any of the European leagues’ results and stats in any manner they see best.