Unformatted text preview: Round the number of months up to the closest whole number. 7. Write a query that produces the following for each employee: <employee name> earns <salary> monthly but wants <3 times salary>. Label the column Dream Salaries. 8. Create a query to display name and salary for all employees. Format the salary to be 15 characters long, left-padded with $ . Label the column SALARY. 9. Write a query that will display the employee's name with the first letter capitalized and all other letters lowercase and the length of their name, for all employees whose name starts with J , A , or M . Give each column an appropriate label. 10. Display the name, hire date, and day of the week on which the employee started. Label the column DAY. Order the results by the day of the week starting with Monday. 11. Create a query that will display the employee name and commission amount. If the employee does not earn commission, put “No Commission.” Label the column COMM....
View Full Document
- Summer '10
- Salary, Column, 15%, six months, new salary