SQL requires the use of the command to enter data into a table. O SELECT O ADD APPEND O INSERT Which command would be used to delete the row from table PRODUCT where the P.CODE is 'BRT- 345'? O REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345: O NULL PRODUCT WHERE P.CODE - "BRT-345: O DELETE FROM PRODUCT WHEREP CODE = 'BRT-345': O DELETE P_CODE - "BRT-345 FROM PRODUCT: When a user issues the DELETE FROM tablename command without specifying a WHERE condition, O all rows will be deleted o the last row will be deleted O no rows will be deleted O the first row will be deleted Assume you have the following table: Staff (No, firstname, lastname, job, salary) Which SQL statement increments the salary of managers by 5%? O UPDATE salary - salary * 1.05 WHERE job = "Manager'; O SELECT FROM Staff SET salary = salary * 1.05 WHERE job= 'Manager': O UPDATE Staff SET salary = salary * 1.05 WHERE job = "Manager': O SELECT salary = salary * 1.05 FROM Staff WHERE job = "Manager: Examine the following subquery: SELECT MAX(cust_total) FROM (SELECT customer_id, COUNT (customer_id) AS cust_total FROM orderdetails GROUP BY customer_id) What is missing from this SQL statement if I want to run it in MySQL? (I forgot to mention this in the videos, that is why I put this question here. But this is explained in the notes, so check it out to make sure you learn it. And you will need to use this in the homework too.) O semi-colon after GROUP BY clause O Quotes for the subqueries O Nothing O An alias for the subquery When you use the SQL UNION operator, the tables output from the queries involved in the UNION must all have the same number of O rows O data types O records O columns When you use UNION, the must be compatible. of the tables output from the queries involved in the UNION rows O names of the columns O data types of the columns O records