I am trying to list the number of inactive versions of a file if more than
ten exist.
Here is what I have so far:

select FILESPACE_NAME,HL_NAME,LL_NAME,count(*) as Inactive_Files from
backups where node_name='NODEX' and state='INACTIVE_VERSION' group by
HL_NAME,LL_NAME,FILESPACE_NAME

Here is the output:

FILESPACE_NAME       HL_NAME              LL_NAME
INACTIVE_FILES
------------------   ------------------   ------------------
--------------
--------------
/                    /
/                    /
3
/home                /
12
/images              /
2
/sa                  /
1
/sa/ca               /
1
/tng/cac             /
1
/tmp                 /                    .oslevel.mlinfo.c-
1
                                           ache
/                    /                    .rhosts
3
/                    /                    .rhosts_bak
3
/tmp                 /                    .sf27036
1
/                    /                    .spgen_rhosts
3
/tmp                 /                    .strload.mutex
1


My question is what do I code now to only get the entry if more than ten
exist (I don't want to see all the entries that only have one inactive
version). I have tried using count(*) > 10, but that doesn't work.