Course- database administration subject- relational database 1-…

Question Answered step-by-step Course- database administration subject- relational database 1-… Course- database administrationsubject- relational database  1- Find the first name, last name of employees who are earning 9000 2- Select all employees whose hire date is between the dates ’03-06-17′ AND ’06-01-03′; 3- Display a list of employees whose first name contains the characters ‘an’. 4- Display the list of employees whose last name has 5 characters 5- Display the list of employees whose the second letter of the last name is a; 6- Write a query to list the first name, last name, and salary for the first 10 employees contained in the employee’s table. 7- Write a query to list the employee’s name and total salary of a year and yearly salary is more than $10000. 8- Write a query to list the name of all the employees who are not working in department number 20. 9- Write a query to list the name, and salary of all the employees where the employee’s first name belongs in a specified list. (Steven, Lex) 10- Display the list of all the cities that have a province Ordered by country id Business Management Project Management CIS 298 Share QuestionEmailCopy link Comments (0)

Leave a Comment

Your email address will not be published. Required fields are marked *