1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Over [174]
3 years ago
13

Problems and Exercises 16 through 43 are based on the entire ("big" version) Pine Valley Furniture Company database. Note: Depen

ding on what DBMS you are using, some field names may have changed to avoid using reserved words for the DBMS. When you first use the DBMS, check the table definitions to see what the exact field names are for the DBMS you are using. See the Preface and inside covers of . List the MaterialID, MaterialName, Material, MaterialStandardPrice, and Thickness for all raw materials made of cherry, pine, or walnut. Order the listing by Material, StandardPrice, and Thickness. Display the product ID and the number of orders placed for each product. Show the results in decreasing order by the number of times the product has been ordered and label this result column NumOrders.
Computers and Technology
1 answer:
lesya [120]3 years ago
3 0

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

You might be interested in
What would be a standard way for anyone outside an agile team( for example, delivery partner partner of the account, head of the
musickatia [10]

Answer:

He/She can refer the physical/digital kanboard ,which is maintained by the team

7 0
3 years ago
Write a summary, on the requirements for a home automation IoT network discussing whether Wi-Fi is the best network option, by c
Wewaii [24]

Answer:

following are the answer to this question:

Explanation:

In the given question, firstly we focus solely on the smart homes IoT systems criteria, that can access the whole IoT notion throughout two ways, which be defined as follows:

Initially, whenever it links with the smart home includes ventilation, flower arranging, smart house appliances, device, and the designers will use search engine support, etc. all of this, including several, includes certain components like sensors, hubs, doorbells, fire detector.

In the second way the cloud control devices described from first are provided, however, manufactures should be recorded here through cloud computing, and when the process, entirely controlled, can easily be managed remotely, because it is first performed.

The Zigbee is a great priority when it comes to energy usage due to the extremely reduced wattage or battery capacity, and when it comes with wifi capacity, the best solution is Zigbee and it is too expensive with memory footprint 9 because this is also a very big one) It also allows all of the implements to enter even before wifi permits.  

Even so, in wifi, we will not ever realize if it will fall to the ground, however in ZigBee and at the start, they only have to pay tremendous like wifi but it has some repayment options, that lead the user can decide whatever they want. It can pay for our consumption levels.

5 0
3 years ago
Five uses of the start button
Damm [24]

Starting something

Possibly turning it off

Making something work

Fixing the Start Button

Beginning something

5 0
3 years ago
How do you view the edited document without the track changes markup?
daser333 [38]

To check a document:

Open the document you want to inspect for tracked changes and comments.

Click the Microsoft Office Button , point to Prepare, and then click Inspect Document.

In the Document Inspector dialog box, click Inspect.

Review the inspection results. ...

Click Reinspect or Close.


3 0
4 years ago
Create a java program that creates two files. Fill each file with 100 random integer numbers between 1 and 20.
Nana76 [90]

Answer:zxsdfghjgfghghmncvbn

Explanation:bnmgfdghjkjhgfgbcxdnmxc  vnchdg  cbhd

4 0
3 years ago
Other questions:
  • Write a functionvector merge(vector a, vector b)that merges two vectors, alternating elements from both vectors. If one vector i
    8·1 answer
  • An automotive engine's camshaft rotates at
    8·2 answers
  • Which of these is an example of open-source software?
    13·1 answer
  • Write the proghrams for the following:
    13·1 answer
  • Once a graph has been created, you would need to start over to make any changes to it. true false
    15·1 answer
  • Why is it saying I don’t have a subscription when I paid for it and it shows deducted from my account? I can’t find any phone #
    7·1 answer
  • True or false. The CPU requires it's own power from the power supply, and can't receive power from the motherboard.
    9·1 answer
  • Setting up a desktop computer for anAutoCADspecialist who needs a minimum of 125 GBram which operating system would be the best
    5·1 answer
  • Explain the different type of shift register counter ​
    14·1 answer
  • can you follow my ikok? its that_enby_skye and my youube Cactus Face with 241 subscribe er s & my twith Mx_Skye
    10·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!