Code and Insights
-- Top 5 courses with high rating and subscribers
​
SELECT *
FROM Udemy_data
ORDER BY Rating DESC, Subscribers DESC, Reviews DESC
​
OUTPUT
-- Most Reviewed courses with subscribers
​
SELECT *
FROM Udemy_data
ORDER BY Reviews DESC, Subscribers DESC
​
OUTPUT
​
​
​
​
​
​
​
​
-- Top 10 free courses based on rating and subscribers on Udemy
SELECT TOP 10 *
FROM Udemy_data
WHERE PaidCourse = 0
ORDER BY Rating DESC, Subscribers DESC
​
OUTPUT
-- High Paid Course with Top Reviews
​
SELECT *
FROM Udemy_data
ORDER BY Price DESC, Reviews DESC
​
OUTPUT
-- Affordable and underrated Courses
SELECT ID, Title, Subscribers,Reviews,Rating, DatePublished, OfferPrice
FROM Udemy_data
WHERE OfferPrice > 0
ORDER BY Reviews DESC, Subscribers DESC
​
OUTPUT
​
​
-- Top 5 SQL courses with high rating and subscribers
​
SELECT TOP 5 ID, Title, Subscribers,Reviews,Rating, DatePublished, OfferPrice
FROM Udemy_data
WHERE Title LIKE '%sql%'
ORDER BY Subscribers DESC, Rating DESC
OUTPUT
​
​
​
​
​
​
​
​
​
​
​
The whole code is posted in GitHub : https://github.com/smzahir/Portfolio-Project
​
