Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks. 1 ales_ID1586 S15851587 S15861588 S15871589 S15881590 S15891591 S15901592 S15911593 S15921594 S15931595 S15941596 S15951597 S15961598 S15971599 S15981600 S15991601 S16001602 S16011603 S16021604 S16031605 S16041606 S16051607 S16061608 S16071609 S16081610 S16091611 S16101612 S16111613 S16121614 S1613ReadySales_Date2021-11-192021-11-192021-11-202021-11-202021-11-202021-11-212021-11-222021-11-222021-11-222021-11-222021-11-222021-11-222021-11-222021-11-232021-11-232021-11-232021-11-232021-11-242021-11-242021-11-242021-11-24 Wheels on Coast2021-11-24 Wheels on Coast2021-11-25 Riders Ltd.2021-11-25 Bikes for Likes2021-11-26 OffRoad Vehicles2021-11-26 Crestfallen2021-11-26 Bikes for Likes2021-11-26 Riders Ltd.2021-11-27 Motorcross EventsInventory DataCustomer_NameBikes for LikesMotorcross EventsOffRoad VehiclesRiders Ltd.SeedMotorcross EventsOffRoad VehiclesMotorcross EventsRiders Ltd.Horshoe IncorporatedRiders Ltd.**************Motorcross EventsOffRoad VehiclesBikes for LikesHorshoe IncorporatedHorshoe IncorporatedHorshoe IncorporatedX GamesRiders Ltd.Horshoe IncorporatedMotorcross EventsSales DataAccessibility: InvestigateItem_IDA1340$A1122$A1312$A1174$A1898$A1654 $A1383 $A1823 $A1897 $A1211 $A1184 $A1467 $A1384 $A1094 $A1309 $A1762 $A1724 $A1932 $A1296 $A1798 $A1373 $A1726 $A1778 $A1293 $A1460 $A1864 $A1662 $A1324 $A1117 $+Aging GroupSales_Amount89,27586,56217,49457,07759,55176,22336,60491,01386,47894,39557,83230,38679,01321,86134,62064,96692,87938,63146,16328,15188,53022,1836,32527,77677,11098,04295,27685,002Payment_Date2021-12-182021-11-272021-12-202021-12-092021-12-082021-12-172021-12-292021-12-252021-12-172021-11-282021-12-152021-12-172021-12-222021-12-112021-12-092021-12-072021-12-052021-12-092021-12-082021-12-112021-12-022021-12-08Appear in A/Rat 2020-12-31Appear in A/Rat 2021-12-3117,49459,55194,39557,8326,32585,00217,099Number of Daysfrom Sales Dateto 2021-12-314141883939363534Aging CategoryOverdue 1-30 daysOverdue 1-30 daysOverdue 1-30 daysOverdue 1-30 daysOverdue 1-30 daysOverdue 1-30 daysOverdue 1-30 daysBSales_Year20212021202120212021202120212021202120212021202120212021202120212021202120212021202120212021202120212021202120212021ItemEngineBrakesBrakesBrakesTireRadioBrakesEngineTireBrakesRadioTireBrakesTireSeatsRadioBrakesBrakesBrakesBrakesRadioTireTireSeatsEngineEngineBrakesEngineSeats135%

function used here is sumif() syntax:- =sumif(range,criteria,sum_range)

Answered: Formula to calculare the total sales…

Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks.

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: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

A: The above question is solved in step 2 :-

Q: In cell C16, enter a formula to calculate the price of the vehicle minus your available cash (from…

A: Cell references in Excel that don't change when they are copied or filled in are known as absolute…

Q: Display the PID as “Product ID”, Desc as “Description”, and SName as “Supplier Name” with their…

A: Here we can use AS operator to rename the query. Also use JOIN clause using the JOIN On condition.

Q: Create a NONCAT table with the structure shown in Figure 6-28. Insert into the NONCAT table the item…

A: - We need to create a NONCAT table.

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Show all the unique joining_date of the users joining in ascending order. Show the name and…

A: Given : Show all the unique joining_date of the users joining in ascending order. Note : To…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: How many distinct visit reasons start with the word "Pain"? Name the result column as NumPainReason.…

A: SELECT COUNT(DISTINCT VisitReason) AS NumPainReason FROM VisitWHERE VisitReason LIKE 'Pain%';

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: Display all customers regardless of orders and also display orders for each customer.

A: Query to display all the customers that have placed an order and those that have not placed the…

Q: Using the WHERE clause, filter the invoice table to find the invoices that were dated after March…

A: The question has been answered in step2

Q: In cell B20, enter a formula to calculate the number of clients the sales associate had with annual…

A: The solution to this task involves using the COUNTIFS function, which allows you to count the number…

Q: Use select statements to create queries that answer the following questions. Only provide the…

A: Queries: 1) SELECT ItemDescription, Price FROM Flower WHERE ItemDescription LIKE '%Bouquet%' AND…

Q: Create a query to produce the total purchase per invoice, generating the results shown in the…

A: DISTINCTROW Keyword: The "DISTINCTROW" keyword omits data based entire duplicate records, not like…

Q: Select FirstName,LastName,department,project_name,hours from employeetab,Project where…

A: This SQL code aims to select certain columns from two tables, employeetab and Project, join them…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Insert in the Current Values section at the top of the worksheet summary functions that use the…

A: Solution:: Click on the cell I2 enter the following formula =SUM(I9:I54)

Q: Create a store procedure that displays the names of salesman located in Paris and their commission

A: So let's understand what are Stored Procedures first. A Stored Procedure is a prepared SQL code…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: 9. SELECT rep.rep_ID,rep.last_name,rep.first_name FROM rep WHERE rep.rep_ID IN (SELECT rep_ID FROM…

Q: Generate a listing of all purchases made by the customers, using the output shown in the following…

A: SQL query The SQL code for sorting the results by invoice number, product description and customer…

Q: To enter Vendors and Expenses transactions: From the Navigation Bar, select Customers From the…

A: BELOW ? STEP BY STEP COMPLETE SOLUTION REGARDING YOUR PROBLEM WITH EXPLANATIONS :

Q: 5. For each order, list the order number, quoted price and the item description, when the category…

A: 5. To get the required results, we need to use ORDERS, OPRDERLINE, ITEM tables Query: SELECT…

Q: I need help with a SELECT statement that returns the cust_id and the total number of orders for each…

A: The objective of the question is to write a SQL SELECT statement that returns the customer ID…

Q: Select Invoice_number, invoice_due_date, payment_date and the number of days late for those invoices…

A: Note: The given query has been compiled and executed in "sqlfiddle" online compiler. Creating an…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student your query get the error because inv_number exist in the two table so you have to…

Q: Write the Excel function to determine the number of salespersons who had a Sales Total above the…

A: use countif function to apply condition in given range countif syntax:- countif(range,criteria)…

Q: As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign…

A: Actually, database is used to stores the data and manipulate, change and modify the data.

Q: Create a procedure named prc_cus_balance_update that will take the invoice number as a parameter and…

A: A stored procedure is a prepared subprogram that can be reused again and again. You can follow this…

Q: list the number of equipment with the same first three letters (the start code, e.g., CAM, DIV) in…

A: THE ans is an given below :

Q: Display the product ID and the number of orders placed for each product. Show the results in…

A: SQL (Structured Query Language) is a database computer language primarily designed for the…

Q: The InstantRide Finance team also wants to analyze travels where more than the average discount rate…

A: Since you have not specified the table name , let us assume that the data is present in TRAVELS…

Q: Create a View to show all the first and last names of managers and the count of their employees.…

A: ANSWER:-

Q: . Please write SQL codes to query data from member tables based on below criteria Please write a…

A: A number is odd number if its remainder when divided by 2 is not equal to 0

Q: For each product, show the product ID and the number of orders placed. Show the results in…

A: Introduction: SQL (Structured Query Language) is a database computer language designed primarily for…

Q: List State, Sales Year, Current Year Sales, Last Year Sales, and Change in Total Yearly Sales for…

A: based on your description, here's an example SQL query that give you the result you're looking for:…

Q: Find out the customers with balance of $3500 or more. Your result should include the most recent…

A: SELECT INVOICE .INV_NUM WHERE TOP INVOICE .INV_DATE DESC, INVOICE .CUST_CODE FROM INVOICE,…

Q: Write the queries to the following tasks: Show all the unique joining_date of the users joining in…

A: Answer: We need to write the SQL query for the given information table. so we will see in the more…

Q: Which clause do you add to the following SELECT statement to limit the display to those categories…

A: SELECT catagory_id, SUM(price) FROM products GROUP by catagoriy_id a. HAVING SUM(price)<5000 or…

Q: Use select statements to create queries that answer the following questions. Only provide the…

A: Two tables are provided. The name of the first table is Order. The name of the first table is…

Question

Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks.

1 ales_ID
1586 S1585
1587 S1586
1588 S1587
1589 S1588
1590 S1589
1591 S1590
1592 S1591
1593 S1592
1594 S1593
1595 S1594
1596 S1595
1597 S1596
1598 S1597
1599 S1598
1600 S1599
1601 S1600
1602 S1601
1603 S1602
1604 S1603
1605 S1604
1606 S1605
1607 S1606
1608 S1607
1609 S1608
1610 S1609
1611 S1610
1612 S1611
1613 S1612
1614 S1613
Ready
Sales_Date
2021-11-19
2021-11-19
2021-11-20
2021-11-20
2021-11-20
2021-11-21
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-23
2021-11-23
2021-11-23
2021-11-23
2021-11-24
2021-11-24
2021-11-24
2021-11-24 Wheels on Coast
2021-11-24 Wheels on Coast
2021-11-25 Riders Ltd.
2021-11-25 Bikes for Likes
2021-11-26 OffRoad Vehicles
2021-11-26 Crestfallen
2021-11-26 Bikes for Likes
2021-11-26 Riders Ltd.
2021-11-27 Motorcross Events
Inventory Data
Customer_Name
Bikes for Likes
Motorcross Events
OffRoad Vehicles
Riders Ltd.
Seed
Motorcross Events
OffRoad Vehicles
Motorcross Events
Riders Ltd.
Horshoe Incorporated
Riders Ltd.
**************
Motorcross Events
OffRoad Vehicles
Bikes for Likes
Horshoe Incorporated
Horshoe Incorporated
Horshoe Incorporated
X Games
Riders Ltd.
Horshoe Incorporated
Motorcross Events
Sales Data
Accessibility: Investigate
Item_ID
A1340
$
A1122
$
A1312
$
A1174
$
A1898
$
A1654 $
A1383 $
A1823 $
A1897 $
A1211 $
A1184 $
A1467 $
A1384 $
A1094 $
A1309 $
A1762 $
A1724 $
A1932 $
A1296 $
A1798 $
A1373 $
A1726 $
A1778 $
A1293 $
A1460 $
A1864 $
A1662 $
A1324 $
A1117 $
+
Aging Group
Sales_Amount
89,275
86,562
17,494
57,077
59,551
76,223
36,604
91,013
86,478
94,395
57,832
30,386
79,013
21,861
34,620
64,966
92,879
38,631
46,163
28,151
88,530
22,183
6,325
27,776
77,110
98,042
95,276
85,002
Payment_Date
2021-12-18
2021-11-27
2021-12-20
2021-12-09
2021-12-08
2021-12-17
2021-12-29
2021-12-25
2021-12-17
2021-11-28
2021-12-15
2021-12-17
2021-12-22
2021-12-11
2021-12-09
2021-12-07
2021-12-05
2021-12-09
2021-12-08
2021-12-11
2021-12-02
2021-12-08
Appear in A/R
at 2020-12-31
Appear in A/R
at 2021-12-31
17,494
59,551
94,395
57,832
6,325
85,002
17,099
Number of Days
from Sales Date
to 2021-12-31
41
41
88
39
39
36
35
34
Aging Category
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
B
Sales_Year
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
Item
Engine
Brakes
Brakes
Brakes
Tire
Radio
Brakes
Engine
Tire
Brakes
Radio
Tire
Brakes
Tire
Seats
Radio
Brakes
Brakes
Brakes
Brakes
Radio
Tire
Tire
Seats
Engine
Engine
Brakes
Engine
Seats
135%

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 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

Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.
Display the total number of credits earned in each year using the tot credits (year, num credits) view.
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
Create a report of departments and their number of current employees, ordered from high to low. Note: The to_date column can be used to select currently working employees. Please make a nice report showing department name
SQL: For every invoice, display the invoice number, invoice date and the total dollar amount for all products purchased in the invoice, ordered by invoice number in descending order and then by invoice date in ascending order. Here you will use an aggregate SUM(x,y) function in your SELECT clause to calculate the total dollar amount (a calculated field – name it TOTAL). Don’t forget to join on the tables as well. [hint: you should have 8 rows of output ordered properly]. select inv_number, inv_date sum(list_price) as 'total' from invoice, line order by desc inv_num, asc inv_date. I am getting the error: ORA-00923: FROM keyword not found where expected Am I formulating the query incorrectly?
In what order are output results displayed if a SELECT statement contains a GROUP BY clause and no ORDER BY clause?
Create the SQL code that will calculate the total number of hours worked and the total amount of money charged by all employees.
Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)
Task 4: Use the EXISTS operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021. This is incorrect: