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 answer is B. Eight bits
Answer:
Yes
Explanation:
We known that TCP is the connection
protocol. So the TCP expects for the target host to acknowledge or to check that the
session has been established or not.
Also the End stations that is running reliable protocols will be working together in order to verify transmission of data so as to ensure the accuracy and the integrity of the data. Hence it is reliable and so the data can be sent A will still be delivered reliably and it is in-sequence at B.
A hypothetical company that needs an information system is Memphis drilling and construction company.
<h3>What is the size of a project?</h3>
This is known to be the the number of firms taking part in the project and thus in the case above, it is small project.
In terms of Staff/experts availability, there are experts from the mining industry with years of experience, soil survey analyst as well as other minor staff.
In terms of System level of criticality, it is big because the extent to drilling will make use of the information system and other major decisions made.
Learn more about information system from
brainly.com/question/14688347
#SPJ1
Answer:
(a) Array
Explanation:
An array is a data structure that can be used to organize 1- or 2-dimensional data in a list.