Which ORDER BY clauses can be added to the above SQL statement to get the correct output?

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.)

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;



Leave a Reply 17

Your email address will not be published. Required fields are marked *


user

user

Why is A and E correct?

indi gnato

indi gnato

why B is not correct?!

davor

davor

Because the question is to sort first according to the prod_LIST_price, not prod_MIN_price.

vic

vic

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!

sahithya

sahithya

Why D is not correct and E is correct?

Sayed

Sayed

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.

Google

Google

Here are a few of the internet sites we advocate for our visitors.

how to make an app

how to make an app

Here are a number of the websites we advise for our visitors

make an app

make an app

here are some links to internet sites that we link to simply because we feel they’re worth visiting

app maker

app maker

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

Joint Custody Child Support

Joint Custody Child Support

just beneath, are several totally not associated web sites to ours, however, they may be surely worth going over

make a app

make a app

usually posts some really interesting stuff like this. If youre new to this site

Pneumatic Actuator manufacturer

Pneumatic Actuator manufacturer

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

how to make money from home

how to make money from home

very couple of internet sites that come about to be comprehensive below, from our point of view are undoubtedly nicely really worth checking out

Handyshop Innsbruck Hall

Handyshop Innsbruck Hall

Sites of interest we have a link to