SQL, count function, lesson 19

SQL count function

Category:

Education

Tags:

• SQL
• count function

[MrStaffy3]

My query is SELECT COUNT (hr.employees e) ‘employees’ FROM hr.employees e, hr.departments d, hr.locations l, hr.jobs l WHERE j.job_id = e.job_id AND l.location_id = d.location_id ACCEPT user_input CHAR PROMPT ‘Please input a location ID or city name’ SELECT * FROM hr.locations l WHERE TO_CHAR (l.location_id) = ‘&&user_input’ OR l.city_name = ‘&&user_input’; ORDER BY COUNT (hr.employees e); I get a missing right parenthesis error, how do I remedy this??