Show first_name, salary and half: 1 for the top-paid half and 2 for the rest (NTILE). Ties go by smaller emp_id first.
first_name
salary
half
emp_id
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.