I NEED POINTSSS if you understand I just don’t know the answer sorry
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
A dedicated server is a single computer in a network reserved for serving the needs of the network. For example, some networks require that one computer be set aside to manage communications between all the other computers. A dedicated server could also be a computer that manages printer resources.
Answer:
13.3%
Explanation:
OEE= Availability × Performance × Quality
Availability = Run Time/ Planned Production Time
Run time = 3*100 = 300 + 0.2* 300 = 1.2 *300 = 360 mins
Planned Production time = 24*60 = 1440 mins
Availability = 360/1440 = 1/4 = 25%..............1
Performance = (Ideal Cycle Time × Total Count) / Run Time
Ideal Cycle Time = 2 min (Only the processing time)
Total Count= 100+20 = 120
Performance = 2*120/360 =66.67% .............2
Quality = 100%-20% = 80%.......3
Frpm 1,2,3
OEE=25% * 66.67 % * 80% =
0.13334=13.3%
