代写Tutorial 5 Structured Query Language (SQL)代写数据库编程

Tutorial 5

Structured Query Language (SQL)

You have been hired as a SQL programmer for QQ Corporation. Your first task is to create some reports based on data from the Human Resources (HR) tables.

1. Your first task is to determine the structure of the DEPARTMENTS table and its contents. 

2. You need to determine the structure of the EMPLOYEES table.

3. The HR department wants a query to display the last name, job code, hire date, and employee number for each employee, with employee number appearing first. Provide an alias STARTDATE for the HIRE_DATE column.

4. The HR department needs a query to display all unique job codes from the EMPLOYEES table.

5. The HR department wants more descriptive column headings for its report on employees. Name the column headings Emp #, Employee, Job, and Hire Date, respectively.

6. The HR department has requested a report of all employees and their job IDs. Display the last name concatenated with the job code (separated by a comma and space) and name the column Employee and Title.

7. The HR department needs your assistance with creating some queries.

Because of budget issues, the HR department needs a report that displays the last name and salary of employees who earn more than $12,000.

      8.        Create a report that displays the last name and department number
                     for employee number 176.

9.         The HR department needs to find high-salary and low-salary    

        employees.  Display the last name and salary         for any employee whose salary is not in the range of $5,000 to               $12,000.

10.         Display the last name, job, and salary for all employees whose jobs are
               either sales representative or stock clerk and whose salaries are not
               equal to $2,500, $3,500, or $7,000.