Select Join and Count

[NZ_Kiwis]

I have two tables, users: userID, userName and then records: recordID, recrodName

I want to display all my users and the number of records they have against each one.

John: 23
Sam: 12
Peter: 102
Doug: 54

This should be easy but I can't get the SQL to work.

[Weedpacket]

You want to use GROUP BY.