SQL Queries
This section showcases the SQL queries that power my portfolio projects—queries I’ve written to efficiently clean, organize, and analyze large volumes of data. Each script reflects my ability to structure datasets for clarity, uncover meaningful patterns, and support decision‑ready insights. From data preparation to complex analytical logic, these queries demonstrate how I use SQL to transform raw information into reliable, actionable intelligence.
Hotel Dashboard
with hotels as (
select* from dbo.['2018$']
union
select* from dbo.['2019$']
union
select* from dbo.['2020$'])
select * from hotels
left join dbo.market_segment$
on hotels.market_segment = market_segment$.market_segment
left join dbo.meal_cost$
on meal_cost$.meal =hotels.meal
Bike Share Dashboard
with cte as (
select* from bike_share_yr_0
Union all
Select* from bike_share_yr_1)
select
dteday,
season,
a.yr,
weekday,
hr,
rider_type,
riders,
price,
COGS,
riders*price as Revenue,
riders*price -COGS*riders as Profits
from cte a
left join cost_table b
on a.yr = b.yr