Advanced SQL - Common Table Expression CTE to find Top selling Products - Episode 4

In this video, i will be using complex SQL. I will use Common Table Expression to Find Top selling products Also Highest rated product. I will also be showing how to handle Decimal Types.
This is a 30 days Series. I am using same database to uncover and answer some complex SQL questions in the form of queries. Pls watch rest of the videos to MASTER SQL ANALYTICS and ACE THE SQL/ BUSINESS ANALYST INTERVIEWS that requires SQL coding.
Queries Include Complex Functions, CTE, SubQuery, Joins, Aggregate columns etc. Pls subscribe for the amazing content and get ready to land on the SQL Coding/ Business Analyst Job.
#TOPsellingproductSQL
#sqlcoding #sqlinterviews #sqlexams #businessanalyst #commontableexpression #cte #sqlDecimalType #SQLWITHCTE
#SQL

[@osoriomatucurane9511]

Why you hard code on the condition/criteria clause ????
Do we need the condition?
Why not
Select product, avg(rating)
From tables......
Group by 1
Order by 2 desc
Limit 5

[@SidraCodes-LetsGo]

There are different ways of doing it but good point. Ill point it in my upcoming videos.