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.

Question 6  List classroom ID, building name, class ID and class description. Use a LEFT JOIN to list all the classrooms in the BSU_Classrooms table and show matching Class ID and class description from the BSU_Class table.  Sort results in descending order by classroom ID.     Paste the SQL code here:     Paste the resulting table here:

PLZ help with the following: Make a discount of 10% for all paintings. Write the SQL command to save all the changes made to the table. Remove a gallery number ‘5’ from the GALLERY table. Is deleting a GALLERY row creates sql file CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567');INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112');INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456');…

For every order that has been received, display the order ID, the total dollar amount owed on that order (you’ll have to calculate this total from attributes in one or more tables; label this result TotalDue), and the amount received in payments on that order (assume that there is only one payment made on each order). To make this query a little simpler, you don’t have to include those orders for which no payment has yet been received. List the results in decreasing order of the difference between total due and amount paid.