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
Back on my #8weeksSQLChallenge. So far, been able to work through the first 4 questions on the first case study. I now get it when @TheRealMasud said you need a lot of critical thinking for data analytics😂.
I'll also be keeping the solutions on a GitHub repository. #AcadicLagos
The first case on the #8weeksSQLChallenge involves using data to answer questions about customers in a restaurant. The datasets (3) used and their relationship can be found in the attached image. I was able to create my own tables and insert values to each columns with SQL.