How can I combine these two queries?
# select viewerid,count(*) from viewer_movies group by viewerid order by viewerid;
viewerid | count
----------+--------
22964835 | 3055
22964836 | 1291
22964837 | 3105
22964838 | 199
planb=# select name from xenons where id = 23500637;
name
---------
x.moray
I would like to end up with a query result like this:
viewer | count
----------+--------
x.surf | 3055
x.dream | 1291
x.moray | 3105
x.sleepy | 199
Many TIA!
Mark
--
Mark Harrison
Pixar Animation Studios