SHARE
TWEET

Udemy Courses Filter QUery

TheDemystifier Jun 13th, 2019 (edited) 33 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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top