Answer:
SQL queries
The command used to display the customer ID and total number of orders placed is given below
Query:
SELECT CustomerID, COUNT (orderID) AS TotalOrders
FROM Order_Table
GROUP BY CustomerID
Explanation:
SQL queries
The command used to display the customer ID and total number of orders placed is given below
Query:
SELECT CustomerID, COUNT (orderID) AS TotalOrders
FROM Order_Table
GROUP BY CustomerID
SELECT - To query the database and get back the specified fields SQL uses the select statement
CustomerID is a coloumn name
The function COUNT(OrderID) returns the number of orders
Totalorderds is a label
FROM - To query the database and get back the preferred information by specifying the table name
Order_Table is a table name
GROUP BY - The clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column
The table below displays the CustomerID and total number of orders placed
CustomerID Totalorders
4 28
1 6
12 5
16 5
6 3
9 3
15 3
3 1
13 1
14 1
The table below shows the total number of orders situated for each sales person
SalesPerson_ID TotalOrders
3 16
2 3
4 3
5 3
The code statement that completes the program is total_coins = nickel_count + dime_count
<h3>How to complete the segment?</h3>
From the code segment, we have the following highlights:
- total_coins is initialized to 0, at line 1
- Inputs for nickel_count and dime_count are taken on lines 2 and 3
- The last line prints total_coins
The above means that total_coins has not been calculated.
This is calculated using:
total_coins = nickel_count + dime_count
The above must be placed before the last line of the program
Read more about code segments at:
brainly.com/question/24833629
#SPJ1
<h3>Complete question</h3>
Complete the code segment to calculate the total number of coins
total_coins = 0
nickel_count = int(input())
dime_count = int(input())
print(total_coins)
A. He has not saved the document yet.
reason being is that most documents today will change their title on what it is thats written on the paper unless you personally change it yourself
