error occuring :ORA-00907: missing right parenthesis . not able execute query
<pre><code>select s.mname,count(distinct s.actorlist) as act 
from p s 
group by s.mname
having count(distinct s.actorlist) = 
                                  (select max(t.act) 
                                  from (
                                        select s1.mname,count(distinct s1.actorlist) as act 
                                        from p s1 
                                        group by s1.mname
                                        ) as t   ); 
</code></pre>

<p>error occuring :ORA-00907: missing right parenthesis . not able execute query
Can someone please help me in finding out the error.</p>