Untitled

From Ample Matamata, 5 Months ago, written in Plain Text, viewed 57 times.
URL http://codebin.org/view/9c26466a Embed
Download Paste or View Raw
  1. SELECT title, user_id, score, ROUND(AVG(score) OVER (PARTITION BY user_id))
  2. FROM stackoverflow.posts
  3. WHERE score > 0 AND (title IS NOT NULL);

Reply to "Untitled"

Here you can reply to the paste above