Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2

Question

Admin · Accepted Answer

Select two columns from the COURSES table, the second one gets as title &ldquo; =PRICE&rdquo;.Sort the data according to the second column, in ascending order.

Admin · Answer

Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. &ldquo; = PRICE&rdquo;. Leave an empty line after every second line.

Admin · Answer

Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. &ldquo; = PRICE&rdquo;. Sort the data according to the second column, in ascending order.

Admin · Answer

None of the above

Q. Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2

Discusssion