Answer:
Explanation:
I will consult the following strategies:
Step 1: Being a discerning consultant I should be knowing what exactly has caused the drive to get corrupted.
Step 2: After examining the current state of the hard drive I will explain the actual problem to the client in a very lucid and eloquent manner whether it is feasible to retrieve the lost data or it is beyond repair.
Step 3: Identify a solution to the problem with things at my disposal(finding a right tool).
Step 4: apply the solution found to retrieve the data from the hard drive.
Step 5: submitting the retrieved data from the corrupt drive to the customer and advocating them the preventive measures for future reference.
The above five steps will work perfectly to resolve the issue faced if followed with great care and being heedful of the situation at hand.
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
Im sorry i just need points
Adware. Adware displays ads and popups. The other options are completely different from each other
