Advertisement
TheDemystifier

Udemy Courses Filter QUery

Jun 13th, 2019
1,238
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT url, title, rating, votes, length, lastUpdated, language
  2. FROM courses
  3. WHERE title LIKE '%%' OR headline LIKE '%%'
  4. ORDER BY rating DESC, votes DESC
  5.  
  6.  
  7. ORDER BY 5*rating/10+5*(1-EXP(-votes/25)) DESC
  8.  
  9.  
  10. 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
Advertisement
RAW Paste Data Copied
Advertisement