Excuse me predecessors: this group inquiry how

CodePudding user response:

I think of the union

The select department_name, job_id, null as the city, the sum (salary) group by department_name, job_id
The union
The select null, null, city, the sum (salary) group by city