Thread: Helpful Posts
View Single Post
Old January 14th, 2016, 11:46 AM   #19
Pigeonherd
ninjette.org member
 
Pigeonherd's Avatar
 
Name: pigeonherd
Location: Quincy, California
Join Date: Jan 2016

Motorcycle(s): 2006 Ninja250, 2014 Honda CB500X, '15CB300F

Posts: 65
SELECT username, count(helpful_post)
FROM ninjette
WHERE user_last_accessed_date =< '01-JAN-2015'
AND helpful_post_date BETWEEN '01-JAN-2015' AND '31-DEC-2015'
ORDER BY count(helpful_post) desc
Pigeonherd is offline   Reply With Quote