Chapter 3, Problem 2.15CP

Use AverageIFS to calculate the average dollar amount of the paid in full transactions over $4,000 in J5.

Driver's name Item Price Transport Destination       John May TV  $                    150.00 truck 4 Boston       Peter White Washier  $                    200.00 truck 3 NY       Carl Anthony microwave  $                       85.00 truck 3 Philadelphia       Peter White TV  $                    120.00 truck 4 NY       Ken Moore refrigerator  $                    350.00 truck 3 Boston       Ken Moore Washier  $                    250.00 truck 1 Philadelphia       John May TV  $                    150.00 truck 4 Boston       Ken Moore microwave  $                    100.00 truck 1 Baltimore       Carl Anthony refrigerator  $                    200.00 truck 2 Baltimore       Peter White Washier  $                    180.00 truck 3 NY                       Use the table above to perform the following functions :-                     countif/countifs Total 1. Count all washiers for Peter White, greater than 150, on truck 3 and headed to NY:       2. Count…

Question 9   Convert the following QUERIES to Stored Procedures with IN parameters In MySQL   select customerNamefrom customerswhere customerNumber in(select customerNumberfrom orders where orderNumberin(select orderNumber fromorderdetails) ); Full explain this question and text typing work only     We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line

e) Display the sum of salaries of employees from each department ordered in ascending order.

In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales.

Problem 21 Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21. SELECTMIN(CUSTOMER.CUS_BALANCE) AS 'Minimum Balance',MAX(CUSTOMER.CUS_BALANCE) AS 'Maximum Balance',ROUND(AVG(CUSTOMER.CUS_BALANCE),2) AS 'Average Balance' FROM CUSTOMER WHERE CUS_CODE IN(SELECT CUS_CODE FROM INVOICE);    This does not work, what am i missing it is suppose to be    Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Data collected (including the normalized values) by a riding mower manufacturer on its existing customers are listed below. Customer ID Income Lot_Size Normalized Income Normalized Lot_Size Ownership 1 61.5 20.8 -0.351 0.762 Owner 2 82.8 22.4 0.726 1.421 Owner 3 52.8 20.8 -0.790 0.762 Nonowner 4 84 17.6 0.786 -0.556 Nonowner 5 63 14.8 -0.275 -1.709 Nonowner The riding mower manufacturer wants to classify a new customer (data given below) as either an owner or a nonowner using k-Nearest Neighbors method. Income Lot_Size Normalized Income Normalized Lot_Size 81 20 0.635 0.532

Consider the following two tables: Draw three tables that can result by executing each of the following SQL statements. .  1.   SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount               FROM Customers AS c               INNER JOIN Orders AS o               ON c. customerID = o. customerID;    2.   SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount   FROM Customers AS c   LEFT OUTER JOIN Orders AS o   ON c. customerID = o. customerID;    3.   SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount   FROM Customers AS c   RIGHT OUTER JOIN Orders AS o               ON c. customerID = o. customerID;

Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with ‘et’ and are décor. 7. Display customer number and location of customer with amount not less than 50. 8. Display all garments and décor items. 9. Display all décor items with prices not less than 10. 10. Display item name, section and price of all accessories with price less than equal to 5. 11. Display the average amount of Nizwa city customers. 12. Display all items with price between 5 and 10. (without using between) 13. Remove duplicate values from the section column of the item table. 14. Display item name, price, customer number of C2 customer.