Create a new table, named Senior Teaching Staff, using the existing teacher table as your source. Senior teaching staff is defined as any teacher that has taught for at least 10 or more years. Do this in a single SQL command (i.e., do not create the table with one command, then insert the records with a separate command). Add a new record to the Senior Teaching Staff table. TeacherId is 568; firstname is Don; lastname is Crumbley, hiredate is not known, supervisor is not known; In the Senior Teaching Staff table, edit record 568 to reflect a hire date of 2005-01-14. 4. After a long debate, the board of education has decided that senior staff should be defined as any teacher that has taught for at least 15 years or more. Delete all the records from the Senior Teaching Staff table that no longer meet the definition of senior staff. 5. on your Senior Teaching Staff table. After running the select *, drop the Senior Teaching Staff table from the Chicago School Database.
Create a new table, named Senior Teaching Staff, using the existing teacher table as your source. Senior teaching staff is defined as any teacher that has taught for at least 10 or more years. Do this in a single SQL command (i.e., do not create the table with one command, then insert the records with a separate command).
Add a new record to the Senior Teaching Staff table. TeacherId is 568; firstname is Don;
lastname is Crumbley, hiredate is not known, supervisor is not known;
In the Senior Teaching Staff table, edit record 568 to reflect a hire date of 2005-01-14.
4. After a long debate, the board of education has decided that senior staff should be defined as
any teacher that has taught for at least 15 years or more. Delete all the records from the Senior
Teaching Staff table that no longer meet the definition of senior staff.
5. on your Senior Teaching Staff table. After running the select *,
drop the Senior Teaching Staff table from the Chicago School
Trending now
This is a popular solution!
Step by step
Solved in 3 steps