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
Answer:
Yes
Explanation:
The ads help support the system for you using this website for free.
<span>It's important that you develop effective strategies for managing your time to balance the conflicting demands of time for study, leisure, earning money and jobhunting. Time management skills are valuable in jobhunting, but also in many other aspects of life: from revising for examinations to working in a vacation job.</span>
<h2>Answer:</h2>
<u>An inserted graphic in Excel is </u><u>B. inserted in the active cell.</u>
<h2>Explanation:</h2>
A graphic is considered as any picture or shape present in the directory of any computer. So when you are working in an Excel worksheet and you insert any graphic so it means you have inserted a shape. It may be a line, picture or any other geometrical shape, then this image or graphic will be inserted in the cell which is active at that time and no where else. Therefore option B is the correct answer.
Answer:
This code will print: 4
Explanation:
Following is the step-by-step explanation for the given code:
- Given is the array of data type double named myList, it has entries, 1, 5, 5, 5,5, 1:
double[] myList = {1, 5, 5, 5, 5, 1};
- Now the first element of the array (1) with index 0 will be stored in the variable max (data type double).
double max = myList[0];
- A variable indexOfMax having datatype int will be initiated as 0.
int indexOfMax = 0;
- Now for loop will be used to find the maximum number of the array. The variable i will be put as index for each element to compare with first element. If the checked element is greater than or equal to the integer in max, it will be replaced. So at the end the variable max will have value 5 that will be at index i = 4.
for (int i = 1; i < myList.length; i++)
{ if (myList[i] >= max)
{ max = myList[i];
- Now the variable i that is the index for max value will be stored in the variable indexOfMax (indexOfMax = 4).
indexOfMax = i; }}
- At end the value stored in variable indexOfMax will be printed, so 4 will be printed as output.
System.out.println(indexOfMax);
i hope it will help you!