(Solved): Database I 1. Write SQL statement to determine the structure of the DEPARTMENTS table and its con ...

Database I

1. Write SQL statement to determine the structure of the DEPARTMENTS table and its contents: 4 I UNP DeICLLeU 2. Write SQL statement to determine the structure of the EMPLOYEES table and its contents. 3. The HR department wants a query to display the last name, job ID, hiredate and employee ID for each employee, with the employee ID appearing first. Provide an alias STARTDATE for the HIRE_DATE column. 4. The HR department wants a query to display all unique job IDs from the EMPLOYEES table. The HR department wants more descriptive column headings for its report on employees. Name the column Emp#, Employee, Job and Hire Date, respectively. The output display the following details: 6. The HR department has requested a report of all employees and their job IDs. Display the last name concatenated with the job ID (separated by comma and space) and name the column Employee and Title. CISB214: DATABASE 1 7. Create a query to display all the data from that table. Separate each column output by a comma. Name the column title THE_OUTPUT