blob: 52f5ec2a2643991b342d14c2a8e66dfe0ac0ede8 [file] [log] [blame]
select store.store_country as c0, `position`.pay_type as c1 from employee as employee, store as store, salary as salary, `position` as `position` where employee.store_id = store.store_id and salary.employee_id = employee.employee_id and employee.position_id = `position`.position_id group by store.store_country, `position`.pay_type order by store.store_country ASC NULLS LAST, `position`.pay_type ASC NULLS LAST;