How to i display the following info from dba_tab_columns

[jlakhani]

Question:
Display a count of tables that have columns greater then 50 and columns less then 50 for a particular schema?

thanks

Ps: I tried the following but I get an error:
SQL> select table_name from dba_tab_columns where owner = 'PRISM' and column_name > 50;

ERROR at line 1:
ORA-01722: invalid number

[davey23uk]

select table_name from dba_tab_columns 
where owner = 'PRISM'
having count(*) > 50 group by table_name

[jlakhani]

Thanks Davey23Uk. You are awesome!!!You Rock!!!