MySQL - counting distinct values

[unixman_again]

In MySQL, how do you generate the query from the table shown? It's something to do with COUNT DISTINCT and GROUP BY (I think) but I can get the flippin' thing to work!

 

Thanks!

 

table                          results that I'd like returned                       
id   uid     course            uid    course     count     
1    122      1                122     1          2
2    122      1                122     2          1
3    122      2                127     1          1
4    127      1                127     2          2
5    127      2
6    127      2

[pcstru]

select uid, course, count(course) from group by uid,course

[unixman_again]

Cheers, that was quick!