View the Exhibit and examine the structure of the PRODUCTS table.
You want to display only those product names with their list prices where the list price is at least double the minimum price. The report should start with the product name having the maximum list price satisfying this condition.
Evaluate the following SQL statement:
SQL>SELECT prod_name,prod_list_price
FROM products
WHERE prod_list_price >= 2 * prod_min_price
Which ORDER BY clauses can be added to the above SQL statement to get the correct output?
(Choose all that apply.)
A.
ORDER BY prod_list_price DESC, prod_name;
B.
ORDER BY (2*prod_min_price)DESC, prod_name;
C.
ORDER BY prod_name, (2*prod_min_price)DESC;
D.
ORDER BY prod_name DESC, prod_list_price DESC;
E.
ORDER BY prod_list_price DESC, prod_name DESC;
Why is A and E correct?
why B is not correct?!
Because the question is to sort first according to the prod_LIST_price, not prod_MIN_price.
The question require col prod_list_price appear firsly by highest value.
So: Order by prod_list_price will appear first and in DESC order.
P/S – This is an easy question turn out hard!
Why D is not correct and E is correct?
D is not correct because it sorts prod_name DESC first then prod_list_price. So it will not satisfy the question of asking prod_list_price DESC.
Here are a few of the internet sites we advocate for our visitors.
Here are a number of the websites we advise for our visitors
here are some links to internet sites that we link to simply because we feel they’re worth visiting
we like to honor numerous other world-wide-web websites on the web, even when they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
just beneath, are several totally not associated web sites to ours, however, they may be surely worth going over
usually posts some really interesting stuff like this. If youre new to this site
that would be the end of this write-up. Right here you will discover some web pages that we consider you will enjoy, just click the hyperlinks over
Here are several of the web-sites we recommend for our visitors
The data talked about within the report are a few of the most effective available
very couple of internet sites that come about to be comprehensive below, from our point of view are undoubtedly nicely really worth checking out
Sites of interest we have a link to