SQL Query for Database
If you have not already done so, 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, 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 into your assignment submission.
Attached is the database script, there is an error:
Msg 213, Level 16, State 1, Line 115
Column name or number of supplied values does not match table definition.
Please explain how to fix the error as well.
“0.
Discount Code: 0
: +1 0 0-0
0..
