Chapter 7, Problem 4AYK

what would you be looking for with the following query? filetype:txt administrator:500:

Create a trigger named trg_pic_hours that automatically updates the PILOT table when a new CREW row is added and the CREW table uses a Pilot CREW_JOB entry. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the PILOT table’s PIL_PIC_HRS only when the CREW table uses a Pilot CREW_JOB entry.

Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include your name.  If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.  On the Sales Data worksheet, enter a formula in cell J4 to find the sales associate's region by extracting the first three characters of the sales associate's ID in cell C4. Use cell references where appropriate. Fill the formula down through cell J64. On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate.  Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.Table EX 6.1 displays calculations for commission rates based on annual sales. IF ANNUAL SALES ARE: THEN THE COMMISSION…

Create a view named RESERVATION_CUSTOMER. It consists of the reservation ID, tripID, trip date, customer number, customer last name, customer first name, and phonenumber. Write and execute the command to retrieve the reservation ID, trip ID, trip date, andcustomer last name for every reservation in the RESERVATION_CUSTOMER viewwith a trip date of September 11 , 2016.   WHAT AM I MISSING OR HAVE INCORRECT ? SELECT Reservation_ID, Trip_ID, Trip_Date, Last_Name FROM RESERVATION_CUSTOMER WHERE TRIP_DATE = '09-SEP-2016';