American InterContinental University Write a T SQL Query Computer Science Task

use MSSQLS Management Studio to create a new database named ch07_ConstructCo. Use the default settings. When the database has been created, run the Ch07_ConstructCo_SQL.txt script linked above to create and load the database tables and data.  

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, and 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.
• Ensure that you have copied and pasted all of the T-SQL statements and verification results