I need help with the select statement that returns the output below using a outer join with table aliases.

Given the below statement, what would happen if the inner query returned an empty list? SELECT * FROM employees WHERE employee NOT IN(    SELECT employeeId FROM employees WHERE departmentId = 14);

The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.

What is the most efficient way to write a trigger that updates a large number of rows?     Specify "for each statement"     Specify "for each row"     Specify "for each table"     Specify "referencing new row"