Q. Which question corresponds best to the following query?SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2 (Solved)
1. Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Leave an empty line after every second line.
2. Select two columns from the COURSES table, the second one gets as title “ =PRICE”.Sort the data according to the second column, in ascending order.
3. Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order.
4. Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order
- c. Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order.