Creative SQL Projects

Explore my showcase of innovative projects with unique designs.

Healthcare

Studying abroad can be both exciting and challenging, leading one Japanese international university to investigate the contributing factors. This project involves using data manipulation skills to explore and analyze data on the mental health of international students, aiming to identify the most impactful factors.

Carbon Emission

Product emissions constitute over 75% of global emissions. This project involves leveraging SQL skills to investigate and identify which industries are the leading contributors to this significant environmental issue.

Electric Vehicles

As electronic vehicles (EVs) gain popularity, the demand for charging stations is growing rapidly. This introductory project involves using a dataset on station usage to assist apartment building managers in gaining insights into their tenants’ EV charging habits.

Manufacturing

This project involves analyzing international debt data collected by The World Bank. The dataset provides insights into the amount of debt (in USD) owed by developing countries across different categories. The objective is to utilize data manipulation skills to determine which countries carry the highest and lowest levels of debt.

Sales

Working on behalf of a company specializing in motorcycle parts, this project involves delving into their data to analyze revenue streams. The focus is on constructing a query to calculate the net revenue generated across different product lines, segmented by date and warehouse.

Finance

Manufacturing processes vary widely, demanding meticulous monitoring to maintain consistent quality. This project utilizes SQL window functions, partitioning, and summary statistics to analyze manufacturing data. The goal is to pinpoint instances where adjustments may have negatively impacted quality, helping the company identify potential errors in their processes.