select rev_actor as actorid,year(rev_timestamp) as year,count(*) as... |
3 years ago |
select rev_actor,count(*)
from revision
where rev_timestamp like... |
3 years ago |
select min(user_editcount),avg(user_editcount),max(user_editcount) from user |
3 years ago |
select *
from user
where user_editcount =(select max(user_editcount) from user); |
3 years ago |