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
Some of the online activities among businesses are:
- SEO consultant. ...
- Web designer or web developer. ...
- Blogger. ...
- Virtual assistant. ...
- Affiliate marketer, etc
<h3>What are Online Activities?</h3>
This refers to the various activities that are done on the world wide web and is usually used by businesses to increase visibility, and in turn, revenue.
Hence, we can see that the use of online activities by businesses are important because the products and services for sale by businesses are advertised to target audiences through some of the aforementioned activities.
Read more about online activities among businesses here:
brainly.com/question/27172895
#SPJ1
Option c is answer because most of us are literature in English
Computer Chips. / SILICON. This is just an educated guess
I am guessing, my guess would be scientific research, managing entertainment, and video game designer