<p>I have a submission table that is very simple: userId, submissionGuid</p>

<p>I want to select the username (simple inner join to get it) of all the users who have more than 10 submissions in the table. </p>

<p>I would do this with embedded queries and a group by to count submissions... but is there a better way of doing it (without embedded queries)?</p>

<p>Thanks!</p>

```
```
select userId, count(*)
from   submissions
having count(*) > 10
group by userId
```
```