SESSION NAME: Advance Select - 2
QUESTION NAME: Employee Salaries TABLE DESCRIPTION:Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than $2000 per month who have been employees for less than 10 months. Sort your result by ascending employee_id.
CODE: select NAME from EMPLOYEE where salary > 2000 and months < 10 order by employee_id;
0 Comments