Having problems with this Query. I am getting the error saying missing expression.
CREATE OR REPLACE VIEW QuestionI1
AS (SELECT e.Employeeid, e.firstname, e.lastname
, sum(nvl(e.salespercent*.01nvl(s.sellprice,0),0)) HighestComm
FROM Employee e
JOIN Salesinv s
ON (e.employeeid = s.salespersonid)
GROUP BY s.salespersonid
HAVING
(select max(sum(nvl(e.salespercent.01*nvl(s.sellprice,0),0)))
FROM Employee e
JOIN SalesInv s
ON (e.employeeid = s.salespersonid)
GROUP BY e.Employeeid)
);