Question: Question 1 a. Create a query that displays the employees names and indicates the amounts of their salaries through asterisks. Each asterisk signifies hundred dollars.

Question 1

a. Create a query that displays the employees names and indicates the amounts of their salaries through asterisks. Each asterisk signifies hundred dollars. Sort the data in descending order of salary. Label the column EMPLOYEE_AND_THEIR_SALARIES.

b. Display the employees name, username, hire date, salary and salary review date, which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format mm/dd/yy. Salary should be rounded. Username is first two letters of the name in the lower case.

c. Use subquery to display all employees, in department location 'BOSTON' with a salary of greater than $1000.

Question 2

a. Write a query to display the employee name, job, and hire date for all employees who started between 01/01/81 to 12/31/81. Concatenate the name and job together, separated by a space and comma, and label the column Employees.

b. Explain the usage of correlated subqueries, inline views with an example.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The ARC Company specializes in developing and selling a wide range of high-quality scooters. Sales representatives report that there is a growing demand for racing scooters. ARC's president, Robin...

Using MySQL, create a query that displays the employees last names, salary, salary divided by 1000 and indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand...

Q.No 2. Consider the following relations: [10 Marks] EMP_NO EMP_NAME EMP_GRADE JOB_ID DEPTNO START_DATE EMP DEPTNO DEPTNAME LOC LOW_SAL HIGH_SAL DEPT Display the name concatenated with the job ID,...

Practice 3: Using Single-Row Functions to Customize Output Write a query to display the system date. Label the column Date. Note: If your database is remotely located in a different time zone, the...

Subject: Oracle DBA Problem A SQL SELECT Given a table definition: Employees( employee_id, first_name, last_name, salary, manager_id, hire_date, commission_pct, department_id) write the following SQL...

Create a query that displays the first eight characters of the employees last names and indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand dollars. Sort the...

Consider the following relations: EMP_NO EMP_NAME EMP_GRADE JOB_ID DEPTNO START_DATE EMP DEPTNO DEPTNAME LOC LOW_SAL HIGH_SAL DEPT Display the name concatenated with the job ID, separated by a comma...

Week 1 Lecture 1 Class Approach to Statistics Statistics is basically a set of tools that allow us to get information out of data sets (we will get to the more formal definition below). As such, it...

Hi how are you? Do you think you can help me answer these questions? ACC 693 Chapter 8 Quiz Note: The material contained within these pages is taken directly from your textbook, Computerized Auditing...

Directions to students: Download the solution to part 1 in the doc share (FILE: Unit 1 ETHICS CASE) or by clicking on the button to the left. Review the solution to parts 1 and 2 in the case. Drawing...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

You have been asked to give a brief speech on how to achieve financial success and financial security. Use the five steps in the financial planning process and the building blocks to achieving...

Suppose that your firm's (pre-loss and pre-tax) earnings one period from now will be $1,000. However, earnings are subject to the following loss distribution: B. What is the net present value of...

Which of the following combines the benefits offered by savings and checking accounts? Question 2 options: 1 ) Retirement account. 2 ) Dedicated savings account. 3 ) Money market savings account. 4 )...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...