Also tried the second suggestion:
words=> select count(action='skip') from words_moves where gid=3 group by
played order by played desc limit 6;
count
-------
1
1
1
1
1
1
(6 rows)
Also tried the second suggestion:
words=> select count(action='skip') from words_moves where gid=3 group by
played order by played desc limit 6;
count
-------
1
1
1
1
1
1
(6 rows)