SQL Data Analysis Interview Question #25/100 | SQL Challenge | SQL Tutorials | Business analyst

Welcome to Day 25 of my 100 Days Challenge!

Join me as I walk through each problem step-by-step, providing detailed explanations and practical tips. Don't forget to like, subscribe, and hit the bell icon to stay updated with daily challenges!

Links:
GitHub Repository - Get the question & datasets

Best Data Analytics Course:

My Other YouTube Videos -
SQL 30 Days Road Map - [Free Learning Resources]

#SQL #DataAnalysis #PortfolioProject #DataCleaning #BusinessAnalysis #DataAnalyst #SQLProject #EDA #SQLTutorial #GitHub #DataScience #CareerInData #LearnSQL #SQLforDataAnalyst #AspiringDataAnalyst #ResumeProject #EndToEndProject

[zero_analyst]

Start Data Career in 2025 (Best Course)

[Deepak-fyl]

Thankful to you for providing this playlist .

[deepthim]

Thankyou for the providing the solution.

[Chathur]

with cte_1 as (
select F.id, F.friend_id as Friend_new, R.rating as rating_1, R2.rating as rating_2
from friends F left join rating R on F.id = R.id left join rating R2 on F.friend_id = R2.id
order by F.id)

select id
from(
select case when rating_1 > rating_2 or (Friend_new is null and rating_1 >85) then id end as id
from cte_1)
where id is not null