Q1. Write the SQL statement to display the employee id, employee name and city of those employees whose designation is “Manager” and annual (yearly) commission is greater than 4000. (hint: the given commission in table is monthly).

Q2.Write the SQL statement to display the employee ids, employee names, departments, cities and countries of those employees whose salary is in between 2000 and 3000.

Answer rating: 100% (QA)

1 Select id name from employ... View the full answer