Question: Instructions Answer the following question below 1. What is the SQL statement for the table structure of table Countries? Explain and discuss all the contents

Instructions Answer the following question below 1. What is the SQL statement for the table structure of table Countries? Explain and discuss all the contents of the SQL statement of table Countries in HR Database 2. Write an SQL statement that will display the content of Employee table 3. Write an SQL statement that will display the Employee ID, Last name, First name and Salary of all employees that 4. Write an SQL statement that will display the Employee ID, Last name, email address, job id of all employees 5. Write an SQL statement that will display the Employee ID, First name, email address of all employees whose 6. Write an SQL statement that will display the Employee ID, Last name, Salary of all employees whose manager's belong to a department with Department ID 20 whose salary are less or equal to 5000 job_ld has a word 'CLERK ID 123 and belongs to a department with department ID 50
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
