Udemy Courses Filter QUery
TheDemystifier Jun 13th, 2019 (edited) 33 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT url, title, rating, votes, length, lastUpdated, language
- FROM courses
- WHERE title LIKE '%%' OR headline LIKE '%%'
- ORDER BY rating DESC, votes DESC
- ORDER BY 5*rating/10+5*(1-EXP(-votes/25)) DESC
- ORDER BY (1 + votes * rating)/((1 + votes * rating)+(1 + votes))-1.65*sqrt(((1 + votes * rating)*(1 + votes))/(POWER((1 + votes * rating)+(1 + votes), 2)*((1 + votes * rating)+(1 + votes)+1))) DESC
RAW Paste Data