What is the formula to calculate this?6. Determine the sales of Engine to X Games in 2021 (round to the nearest whole number). 123456789101129AS6S7S8S9S1012S1113 S1214S1315S1416S1517S1618S1719S1820S1921S2022S2123S2224S2325S2426S2527S2628S27S28S29S30S31303132Sales_IDS1S2S3S4S5BCCustomer_NameOffRoad VehiclesX GamesX GamesCrestfallenX GamesX GamesWheels on CoastOffRoad VehiclesSales_Date2020-01-072020-01-072020-01-072020-01-072020-01-072020-01-072020-01-082020-01-082020-01-08 Bikes for Likes2020-01-082020-01-082020-01-08Motorcross EventsCrestfallenMotorcross EventsX GamesMotorcross Events2020-01-082020-01-082020-01-092020-01-092020-01-092020-01-092020-01-092020-01-092020-01-092020-01-092020-01-092020-01-092020-01-112020-01-112020-01-12X GamesMotorcross EventsHorshoe IncorporatedX GamesMotorcross EventsX GamesOffRoad VehiclesWheels on CoastOffRoad VehiclesMotorcross EventsOffRoad VehiclesMotorcross EventsMotorcross EventsCrestfallen2020-01-12 OffRoad Vehicles2020-01-13 Motorcross Events2020-01-13 X Games2020-01-12DItem_IDA107A110A198A253A290A30A113A140A158A12A152A153$$A183A197 $A244 $A163 $A227 $A8 $A9$A125$A129$A143$$A170A190A117 $A200 $A239 $A248 $A269 $A282 $A27 $$$$$$$$$$$FSales_Amount2,13578,08328,4983,07155,79220,52822,70310,79776,08633,6837,03837,04311,8218,83232,28512,69380,22133,03290,11528,07924,72074,82952,28134,87945,75745,64547,7298,79750,23432,48443,142GPayment_Date2020-01-242020-01-212020-01-162020-01-112020-03-242020-01-252020-01-142020-01-242020-02-062020-03-282020-01-192020-04-042020-02-082020-01-262020-03-202020-01-282020-01-172020-02-282020-02-202020-02-192020-04-292020-02-012020-01-152020-01-262020-07-072020-02-262020-01-172020-03-012020-02-062020-02-272020-03-27HAppear in A/Rat 2020-12-31IAppear in A/Rat 2021-12-31JNumber of Daysfrom Sales Dateto 2021-12-31KAging CategoryLSales_Year2020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020MItemTireTireTireRadioBrakesEngineSeatsTireRadioTireBrakesEngineEngineBrakesSeatsBrakesSeatsBrakesBrakesTireSeatsSeatsTireSeatsTireEngineSeatsRadioTireBrakesBrakesN

Excel:- Excel is a collection of worksheets. A worksheet is a collection of a number of rows and…

Answered: What is the formula to calculate this?…

Engineering

Computer Science

What is the formula to calculate this? 6. Determine the sales of Engine to X Games in 2021

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

Related questions

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: Use the averageif function to calculate the average number of girs and average number of boys.

A: The AVERAGEIF function in Excel is a statistical function that calculates the average of selected…

Q: Calculate the number of days that have passed between your birthday and the current date using an…

A: Given: Calculate the number of days that have passed between your birthday and the current date…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: Find the temperature in increasing order of all cities a) SELECT city FROM weather ORDER BY…

A: Question. Find the temperature in increasing order of all cities SELECT city FROM weather ORDER BY…

Q: Calculate the profit (profit) as the retail price minus the wholesale price

A: Note: Since programming language is not mentioned in the question, we will answer this program in…

Q: Use the 2019 census data to find the median county population in Pennsylvania, New York, and New…

A: The question asks for specific SQL tasks based on different datasets:1. Find the median county…

Q: what is the sql query needed to get total number of beers?

A: SQL (Structured Query Language) is a standardized programming language that is used to oversee…

Q: If every student at a school is assigned a 4-digit person ID number, but 0 and 1 are not used in ID…

A: The question asks about the potential number of student ID numbers in a school where each student is…

Q: Using an UPDATE statement, give all cardiologists in hospital 'H120' a 13 % salary increase. Your…

A: Actually, database is used to stores the data or information.

Q: so how many comparisons about 20 & 45?

A: The JAVA code is given below with comparisons

Q: Check the current stock to see what categories of books are available. Once per category only…

A: Because of this, we make use of the DISTINCT clause so that we may get rid of data set by getting…

Q: 1. Which customers live in New Jersey? List each customer’s last name, first name, and state.

A: The solution is given in next step: Let's say that the table's name is Customer for the moment.

Q: USE MY SQL List all the data in your table movie_prod, sorted by the id of the movie (smallest…

A: MySQL is based on the SQL programming language and allows developers to store, organize, and…

Q: write a MySQL procedure to retrieve and output the item number, description, storehouse number, and…

A: Always prefer to provide database of table.

Q: What was the sum of all sales made during September 2015? A sale amount is defined as…

A: NOTE: The programming language is not mentioned. So, the program is written in Python language.…

Q: Determine which orders had a higher total amount due than order 1008.

A: Explanation: The following query determines the orders where the total amount is higher than order…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: Change to use the database frozenfood Alter table customerOrder add column total as data type…

A: Note: As per our guidelines we can able to solve only three questions. So, please re-post the…

Q: Calculate Euclidean distance, Manhattan distance and Supremum distance between all samples in the…

A: In this question we have to Calculate Euclidean distance, Manhattan distance and Supremum distance…

Q: Determine which books cost less than the average cost of other books in the same category.

A: Given: A relation BOOKS is provided with attributes (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL,…

Q: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: Find the listing of customers who did not make purchases during the invoicing period. Sort the…

A: SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate data in…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

Q: • Find out all the customers who stayed in the Grosvenor hotel during October. Oct. 1 • Minimize the…

A: Given, Below query minimizes the conditions by using the BETWEEN operator for both dateFrom and…

Q: In cell K1, enter a formula using the MAXIFS function to find the NO. Participants where the cost is…

A: Businesses must often examine their data to make educated choices. Finding the maximum value of a…

Concept explainers

Payback Period

Payback period analysis is a method used to determine the relative time value of a project. It measures the time that a project will take to return its initial investment. The total time taken by the project to return the initial investment made for the project is called the payback period.

Question

What is the formula to calculate this?

6. Determine the sales of Engine to X Games in 2021 (round to the nearest whole number).

1
2
3
4
5
6
7
8
9
10
11
29
A
S6
S7
S8
S9
S10
12
S11
13 S12
14
S13
15
S14
16
S15
17
S16
18
S17
19
S18
20
S19
21
S20
22
S21
23
S22
24
S23
25
S24
26
S25
27
S26
28
S27
S28
S29
S30
S31
30
31
32
Sales_ID
S1
S2
S3
S4
S5
B
C
Customer_Name
OffRoad Vehicles
X Games
X Games
Crestfallen
X Games
X Games
Wheels on Coast
OffRoad Vehicles
Sales_Date
2020-01-07
2020-01-07
2020-01-07
2020-01-07
2020-01-07
2020-01-07
2020-01-08
2020-01-08
2020-01-08 Bikes for Likes
2020-01-08
2020-01-08
2020-01-08
Motorcross Events
Crestfallen
Motorcross Events
X Games
Motorcross Events
2020-01-08
2020-01-08
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-09
2020-01-11
2020-01-11
2020-01-12
X Games
Motorcross Events
Horshoe Incorporated
X Games
Motorcross Events
X Games
OffRoad Vehicles
Wheels on Coast
OffRoad Vehicles
Motorcross Events
OffRoad Vehicles
Motorcross Events
Motorcross Events
Crestfallen
2020-01-12 OffRoad Vehicles
2020-01-13 Motorcross Events
2020-01-13 X Games
2020-01-12
D
Item_ID
A107
A110
A198
A253
A290
A30
A113
A140
A158
A12
A152
A153
$
$
A183
A197 $
A244 $
A163 $
A227 $
A8 $
A9
$
A125
$
A129
$
A143
$
$
A170
A190
A117 $
A200 $
A239 $
A248 $
A269 $
A282 $
A27 $
$
$
$
$
$
$
$
$
$
$
F
Sales_Amount
2,135
78,083
28,498
3,071
55,792
20,528
22,703
10,797
76,086
33,683
7,038
37,043
11,821
8,832
32,285
12,693
80,221
33,032
90,115
28,079
24,720
74,829
52,281
34,879
45,757
45,645
47,729
8,797
50,234
32,484
43,142
G
Payment_Date
2020-01-24
2020-01-21
2020-01-16
2020-01-11
2020-03-24
2020-01-25
2020-01-14
2020-01-24
2020-02-06
2020-03-28
2020-01-19
2020-04-04
2020-02-08
2020-01-26
2020-03-20
2020-01-28
2020-01-17
2020-02-28
2020-02-20
2020-02-19
2020-04-29
2020-02-01
2020-01-15
2020-01-26
2020-07-07
2020-02-26
2020-01-17
2020-03-01
2020-02-06
2020-02-27
2020-03-27
H
Appear in A/R
at 2020-12-31
I
Appear in A/R
at 2021-12-31
J
Number of Days
from Sales Date
to 2021-12-31
K
Aging Category
L
Sales_Yea
r
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
2020
M
Item
Tire
Tire
Tire
Radio
Brakes
Engine
Seats
Tire
Radio
Tire
Brakes
Engine
Engine
Brakes
Seats
Brakes
Seats
Brakes
Brakes
Tire
Seats
Seats
Tire
Seats
Tire
Engine
Seats
Radio
Tire
Brakes
Brakes
N

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
city store sid $1001 S1002 S1003 store table True False sid n city Union Edison Newark price sell m sid 51001 51001 S1003 sell table pid product The values in the above 3 tables do NOT violate the E-R diagram. name name price Ipad 300 Iphone 550 Iphone 250 pid 1234 3456 3456 product table name Ipad Iphone Iwatch
Based on the picture please help me write an SQL querey for each (don't answer the actual question just please write an SQL querey) Write an SQL Query to list the name(s) and address(es) of employees who work at the department named- 'Human Resources’? (Hint: Use Table Joining) Write an SQL Query to list the names of all projects run by the department – ‘IT Transformation’? (Hint: Use Table Joining) Write an SQL Query to list the department number and the count of projects in each of these departments and only display those values that has more than 3 count. Rename the count column as ‘Project Count’. (Hint1: Use GROUP BY and HAVING. You need not use table joining) (Hint2: It is OK to see an empty outcome as long as your query is correct) Write an SQL Query to count unique ‘Female’ employees who have been designated as ‘Staff’ and also have worked for more than 20 hours on a single project? Rename the count value as ‘Employee Count’ (Hint: Use Table Joining).
Find the total revenue generated by each product in the past quarter (last 3 months), you would need the following tables and their respective columns: Orders table: order_id (Primary key) order_date Order_details table: order_id (Foreign key) product_id (Foreign key) quantity price_per_unit Products table: product_id (Primary key) product_name
To compute the number of days between your birthday and the current date, which Oracle function should you use?
Do all the sub parts
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
pythin in file and list , I want to make list of month from Jan to Dec , and enter sales for each month . Make average , total , minimum and max sales .
#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
1. List the book title and retail price for all books with a retail price lower than the averageretail price of all books sold by JustLee Books.
3. Which books aren’t in the Fitness category? List each book title and category.
1. Determine the total profit generated by sales to customer 1017. Note: Quantity should be reflected in total profit calculation.