Hi Data Fam.
I recently completed the first two sections of the #8weekssqlchallenge.
I haven’t written a full report on them but here is a link to the full code on my GitHub.
github.com/TemiTayo2304/d…
I would really really appreciate any feedback or corrections. Thank you 😊
Good morning 😃
Just completed the first case study of #8weekssqlchallenge after showing me 🤨 but I have actually learnt a lot from it
@Jessicalevi13 Na you dey motivate me.🥰
#SQLAugust
Day 6 of #100DaysOfCode
I finally completed Case Study 1 in #8WeeksSQLChallenge by Danny Ma😁.
To achieve my result, I applied;
SELECT
CASE
JOIN
SUBQUERY
AGGREGATE FUNCTION
DENSE_RANK
WHERE
CTEs
GROUP BY
ORDER BY
DISTINCT
ALIAS
LIMIT Statements, etc.
#DataAnalytics#SQL
My first use of the windows functions in SQL to answer a business question.
The windows function is one part of SQL that I working towards getting a firmer grasp of.
Thank you @phaibooboo for calling my attention to it.
#8weeksofSQL#8weeksSQLchallenge#Dannyma