You work in your organization's inventory department. At the end of each year, you need to determine the remaining quantity of each product that the organization sells. At the end of the year, you need to send to the planning departmer report that contains the number of products for which the remaining quantity is below the "100" threshold in order to acquire a new quantity for these products. Which of the following formulas is entered in cell D18, outlined in red, to obta the number of products for which the remaining quantity is under 100? Product Unit Price $ Available Quantity Delivery Date Delivered Quantity Remaining Quantity 2 Product 1 $1,071 210 15-Jan-19 53 158 3 Product 2 $1,414 277 15-Jan-19 69 208 4 Product 3 5 Product 4 6 Product 5 7 Product 6 $1,866 366 29-Jan-19 91 274 $634 124 23-Feb-19 12 112 $216 42 20-Mar-19 11 32 $380 74 14-Apr-19 19 56 8 Product 7 $668 131 09-May-19 33 98 9 Product 8 $1,176 170 03-Jun-19 39 131 10 Product 9 $2,070 161 28-Jun-19 108 53 11 Product 10 $2,546 198 23-Jul-19 133 65 12 Product 11 13 Product 12 14 Product 13 15 Product 14 $3,132 244 17-Aug-19 163 80 $3,069 239 11-Sep-19 107 131 $3,008 234 06-Oct-19 105 129 $2,947 $2,888 229 31-Oct-19 170 59 16 Product 15 225 25-Nov-19 132 93 17 18 Number of products 8. Select the single best answer: A. =COUNT(F2:F16,"<=100") B. =IF(F2"<=100" ISNUMBER(F2:F16),0)

The data section called Transaction Growth shows how many clothing sets were sold each month. Felicia entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. She notices that all of the values in the range are 2,146, even though more clothing sets than this were sold in some months. Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.

Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT.

Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.

Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:

Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner’s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.

where 'Where clause' used ?

4. Display a list of all book titles and the percentage of markup for each book. The percentageof markup should be displayed as a whole number (that is, multiplied by 100) with nodecimal position, followed by a percent sign (for example, .2793 = 28%). (The percentageof markup should reflect the difference between the retail and cost amounts as a percent ofthe cost.) SQL commands

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.

Question 13: Evaluate ACE16 +102 10 and show the answer in octal form.