In cell B3, insert the SUMIF function to calculate the total orders for Austin (cell B1). Useappropriate mixed references to the range argument to keep the column letters the same.Copy the function to the range C3:D3.7In cell B4, insert the AVERAGEIF function to calculate the average number of days forshipments from Austin (cell B1). Use appropriate mixed references to the range argument tokeep the column letters the same. Copy the function to the range C4:D4.9Now you want to focus on shipments from Houston where the order was greater than$1,000.In cell C7, insert the COUNTIFS function to count the number of orders where the AirportCode is IAH (Cell D1) and the Order Total is greater than $1,000.In cell C8, insert the SUMIFS function to calculate the total orders where the Airport Code isIAH (Cell D1) and the Order Total is greater than $1,000.10In cell C9, insert the MAXIFS function to return the highest order total where the Airport Codeis IAH (Cell D1) and the Order Total is greater than $1,000.11 StatisticsAUSDFWIAH# of ShipmentsTotal Order ValueAverage # of DaysHouston (IAH) Orders Over $1,000Number of Orders ShippedTotal of Orders ShippedHighest Order ValueAirportOrderDate Ordered Total Days4/5/20214/5/20214/5/2021CodeTotal4AUS$975$ 1,055$ 1,075$ 1,000$ 2,535$ 1,89010AUS11IAH4/5/20217DFW4/5/202111IAH4/5/20214/5/20217DFW11AUS9504/6/20219DFW$ 1,4854/6/20214/6/20213DFW$550$ 1,250$ 1,600$ 2,500$ 1,42513AUS4/6/20218IAH4/6/202113DFW4/7/2021IAHWeekStatsMapLoan

Answered: In cell B3, insert the SUMIF function…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20
In the range C15:G15, insert a function to calculate the total daily revenue. In the range H11:H15, insert a function to calculate the weekly totals for the seating categories and grand total. What are the functions?
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
The APPT_DTTM column stores the date and time of an appointment. Which of the following expressions would return TRUE for all appointments on January 1, 2018, and FALSE for all other appointments? SELECT ONE OF THE FOLLOWING A. APPT_DTTM >= '1 JAN 2018' AND APPT_DTTM < '2 JAN 2018' B. APPT_DTTM = '1 JAN 2018' C. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM <= '1 JAN 2018' D. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM < '2 JAN 2018' Choose one correct answer and what is output of remaining queries with proper explanation
I need to merge three datasets so that I can create a custom function that would do the following: Create a function called theme_by_year that takes as input a year (as an integer) and shows the theme ids and theme names (listed in order by theme id) that were in sets that year. The column names must be id and name_themes (to differentiate between the name of a theme and the name of a set) in that order. The index should be reset and go from 0 to n-1. Each theme should only be listed once even if it appeared in more than one set from that year -- duplicate themes should be based on theme id and not name since there are some themes with the same name but with a different id. Hint: It will help if you were to think about merging appropriate DataFrames to help you get this answer. The desired output should look like this: theme_by_year(1960) Output: id name_themes0 371 Supplemental1 497 Books2 513 Classic Here's what I tried, but I did not get the desired output:
Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C9 to the range C9:C54. Hide column B that contains the codes.
The Marketing team of InstantRide wants to know that how many discounts have been offered for each ride. You need to calculate this information for each travel where a discount is applied and return two columns: TRAVEL_ID and DISCOUNT_AMOUNT. In addition, you need to return the calculation as a money value using the ROUND function to 2 decimals.
The following statement uses a non-correlated subquery to find the South American country with the smallest population: SELECT * FROM Country WHERE Continent = 'South America' AND Population = (SELECT MIN(Population) FROM Country WHERE Continent = 'South America')\G Rewrite the statement to use a correlated subquery.
"Create a stored procedure named spPriceRange that accepts two optional parameters. Theprocedure should return a result set consisting of Product Id, Product Name, ProductDescription, and List Price from the product and product description tables for each productwithin the price range, sorted with largest price first. The parameter @PriceMin and @PriceMaxare parameters used to specify the requested range of prices. If the minimum price is notprovided use the minimum non-zero price in the product table. If the maximum price is notprovided use the maximum price in the product table."
Find a way to take use of information technology to provide yourself and your business a competitive edge, and then employ that technology.
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
Update the validateForm() function to verify the phone number is exactly 10 characters long. Display "Phone number is invalid" in the console log if the phone number does not meet the requirements. Use the preventDefault() function to avoid submitting the form when the input is invalid.

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS