Q1.Write the SQL statement to display employee names, designation and cities of those employees whose designation starts with “M” and ends with “R” and whose salary is greater than 2500.

Q2.Display the following results: 

• Write the SQL statement to display the hire days of all employees (All days must come in one column). 
• Write the SQL statement to ROUND OFF all the salaries up to 2 decimal places.

Answer rating: 100% (QA)

SELECT name designation city F... View the full answer