Examine the structure of the transactions table:
You want to display the date, time, and transaction amount of transactions that where done before 12 noon.
The value zero should be displayed for transactions where the transaction amount has not been entered.
Which query gives the required result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
ExplanationExplanation/Reference:
O would turn into a Char data value implicitly