Question: SELECT PROJ _ NAME, PROJ _ VALUE, PROJ _ BALANCE, EMP _ LNAME,EMP _ FNAME, EMP _ INITIAL, EMPLOYEE.JOB _ CODE, JOB _ DESCRIPTION, JOB

SELECT PROJ_NAME, PROJ_VALUE, PROJ_BALANCE, EMP_LNAME,EMP_FNAME, EMP_INITIAL, EMPLOYEE.JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR
FROM
EMPLOYEE
JOIN
JOB ON EMPLOYEE.JOB_CODE = JOB.JOB_CODE
JOIN
PROJECT ON EMPLOYEE.EMP_NUM = PROJECT.EMP_NUM
ORDER BY PROJ_VALUE;
Make comments on it

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 Programming Questions!

Q:

Answer 15,16,17,18,19,20,21,22,23 15. Write the SQL code required to list all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in...

Q:

Question 1 and 2 1. Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for...

Q:

Problem 2 Using the EMPLOYEE, JOB , and PROJECT tables in the ChO7_ConstructCo database, write the SQL code that will join the JoB EMPLOYEE , and PROJECT tables using common attributes. Display the...

Q:

Problem 2 Using the EMPLOYEE, JOB , and PROJECT tables in the ChO7_ConstructCo database, write the SQL code that will join the JoB EMPLOYEE , and PROJECT tables using common attributes. Display the...

Q:

2. Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP_NUM as the common attribute. Display the...

Q:

Question 1 and 2 figure p7.2 1. Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words,...

Q:

Question 1 and 2 1. Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for...

Q:

1. Using Figure P7.1 in the text as a guide, write the SQL/DDL to create the Job and EMPLOYEE tables Note the cardinality requirements for the relationship indicates a foreign key and values are...

Q:

Trying to solve this question but getting an error, please help me to find out an error. Here is the qurstion, i already figure out for job but getting error on EMP_1 Here is my answer where i am...

Q:

I need help with question 31. I just need help with the emp table. Here is the data records for emp table You can show me first few records then i will do it my by self. I just want to know syntax so...

Q:

A deposit of 1 is made at the end of each year for 30 years into a bank account that pays interest at the end of each year at j per annum. Each interest payment is reinvested to earn an annual...

Q:

Recall the discussion in Section 4.7, part (ii), of trade in which Fujifilm has a cost advantage. Draw a diagram showing the effect of trade on U.S. consumer surplus, Kodak profit, and U.S. social...

Q:

Complete the following statement: When the $US weakens against foreign currency A , accounts receivable denominated in foreign currency A will result in an exchange , while accounts payable...

Q:

Find the domain of the function f(x) {x| x=11} O{x | x-11 and x = 1} {x| x= -11} {x| x = 10} Ox| x11 and x = -10} x+10 = x+10x11