Question

Table: consultation
consultationid
patientid
specialistid
fees
consultationdate
101
P500
$300
200
24-Apr-19
102
P501
$301
200
14-May-19
103
P500
$300
200
19-Jun-19
104
P501
S302
350
16-Jun-19
105
P500
$301
250
23-Jun-19
106
P502
$302
200
13-Jul-19
107
P503
$303
400
30-Jul-19
Query:
SELECT consultationid FROM consultation
ORDER BY fees DESC, TO_CHAR(consultationdate, 'Mon');
Which of the following consultationid will be present in the sixth row when

Answer 1

Answer:

Did you mean: Table: consultation consultationid patientid specialists fees consultation date 101 P500 $300 200 24-Apr-19 102 P501 $301 200 14-May-19 103 P500 $300 200 19-Jun-19 104 P501 S302 350 16-Jun-19 105 P500 $301 250 23-Jun-19 106 P502 $302 200 13-Jul-19 107 P503 $303 400 30-Jul-19 Query: SELECT consultationid FROM consultation ORDER BY fees DESC, TO_CHAR(consultation date, 'On'); Which of the following consultationid will be present in the sixth row when

Explanation:

gave me one point