Justus-coded · September 30, 2020 14:33
diff --git a/Employee Salaries.sql b/Employee Salaries.sql
 /*
 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  months. 
 Sort your result by ascending employee_id.
 */

 SELECT name
 FROM Employee
 WHERE (salary > 2000) AND (months< 10)
 ORDER BY employee_id;
	/*
	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 months.
	Sort your result by ascending employee_id.
	*/

	SELECT name
	FROM Employee
	WHERE (salary > 2000) AND (months< 10)
	ORDER BY employee_id;