title: ORA-00907: missing right parenthesis while adding a new column
body: <pre><code>create table student (
         name varchar2(20),
         s1 number(3),
         s2 number(3),
         s3 number(3)
  );
  
  insert into student values('ashok',50, 90, 70);
  
  select name,s1,s2,s3, s1+s2+s3 "Total" 
  from student;
  
  select name,s1,s2,s3,if((s1+s2+s3)&gt;(105)){'pass'}   "Total" 
  from student 
  group by name;
  </code></pre>
  
  <p>can anyone help how to print new column student is pass or fail seeing each subject. </p>