Database name: Ch07_ConstructCo Write a T-SQL query for the constructco tables t

Question

Database name: Ch07_ConstructCo

Write a T-SQL query for the constructco tables to list the employee last name, first name, job code and hire date from the employee table.

Write a T-SQL query for the constructco tables to list the employee last name, first name, hire date where the hire date is greater than 2000-01-01.

Write a T-SQL query for the constructco tables to list the employee last name, project number, assigned job from the employee and assignment tables where the employee table employee number is equal to the assignment table employee number.

Explanation / Answer

i) SELECT last_name,first_name,job_code,hire_date FROM constructco

ii) SELECT last_name,first_name,job_code,hire_date FROM constructco WHERE hire_date > '2000-01-01'

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.