Answer:
SELECT product_name, SUM(DISTINCT quantity) AS total_quantity
RANK() OVER (PARTITION BY total_quantity ORDER BY product_name) AS rank,
DENSE_RANK () OVER (ORDER BY quantity DESC) AS dense_rank
FROM Order_items
JOIN products ON Order_items.product_id = products.product_id
GROUP BY product_id
Explanation:
The SQL query returns four columns namely, product name, total quantity, rank and dense rank. The query uses the rank and the dense rank function to return the rows according to numeric ranks.
Answer:
Explanation:
Computer accepts some data for its processing, that data is called input. The hardware component which allows user to enter data and instruction into a computer is called input device.
The answer is OCR or optical character reader.
This device is used to electronically sorts mails by zip code.
This device reads texts from the papers or documents, images and pdf files, and then convert it into editable file.
Answer:
The correct answer to the following question will be "Marketspace".
Explanation:
- A relatively new marketing term which seems to be a simulated market place. It's an area for the electronic exchange of ideas and information in which external boundary restrictions are removed, termed as Marketspace.
- The electronic trading world focused on connectivity often filled by advanced computer and telecommunications technology and digitized deals.
Therefore, Marketspace is the right answer.
Answer:
The answer to this question is given below in the explanation section.
Explanation:
The iteration variable begins counting with 0 or 1.
As you know the iteration mostly done in the looping. For example, for loop and foreach loop and while loop, etc.
It depends upon you that from where you can begin the counting. You can begin counting either from zero or from one.
For example: this program counts 0 to 9.
<em>int total=0;</em>
<em>for(int i=0; i>10;i++)</em>
<em>{</em>
<em>total = total+i;</em>
<em>}</em>
Let's suppose, if you want to begin counting from 1, then the loop should look like below:
<em>int total=0;</em>
<em>for(int i=1; i>10;i++)</em>
<em>{</em>
<em>total = total+i;</em>
<em>}</em>
