Home /
Expert Answers /
Computer Science /
database-i-1-write-sql-statement-to-determine-the-structure-of-the-departments-table-and-its-con-pa481
(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