SQL Projects

These projects were sourced from Hackerrank, LinkedIn Learning and as well as my own coursework from Tufts University's Engineering department. I do not own the rights to these images and only claim ownership of the solutions while certifying that no generative AI was used in the coding process.

While most projects write-ups are made available in PDF formats, my database design projects are housed within a GitHub repository.

To navigate back to the homepage, simply click on the 'L' logo above.

OCTOBER 2023

The Blunder

Using Aggregation functions to obtain the source of an average salary miscalculation due to omission errors

Top Earners

Using Aggregation and Nested Select functions to identify number of workers earning the highest compensation at a firm

Weather Observation Station

Using Aggregation functions to calculate the distance between coordinates

NOVEMBER 2023

Most Expensive Order

Using Joins, Group by and Order by functions to decipher which order sourced the highest sale amount

Average Order

Using Joins, Group by and Nested Select functions to calculate how much each order brings in for a restaurant on average

DECEMBER 2023

Vendor Integration

Using various E(T)L process functions such as Concat and Substr to supply a vendor with information needed to enroll employees in a certain benefit/service

Email Marketing Performance

Using CTE and Join functions to extract data from floodlights needed to assess performance after a campaign launch

Monthly Product Revenue

Using Date_trunc and Aggregation in conjuction with a CTE to find the higher performing product offering for each month in a previous year

JANUARY 2024

A/B Test on Site

Using Case, Joins & Aggregate functions to create a pivot for the number of floodlight events on a newly designed page

Payment Funnel Analysis

Using Case, Left Join & Nested CTE functions to count how many subscription leads are at each funnel stage.

Subscription Upselling Opportunity

Using Case, Group Concat and CTE functions to identify upsell opportunities for a product team.

FEBRUARY 2024

User Retention

Using Union, Concat and CTE functions to determine how many users are being priced out of a product.

MoM Revenue

Using a self-join to calculate MoM revenue insights for an EoY all-hands.

Quota Regression Analysis

Using a Window function to calculate the running totals and the quota progress of a sales team.

MARCH 2024

Delivery Service

Showcasing DDL (Data Definititon Language) skills developed in PostGre SQL for a food delivery service based in the city of Chicago

Sober E-commerce

Database design for an online store specializing in non-alcoholic beverages such as NA spirits, beers & canned mocktails. Added to derive revenue and inventory.