Your customer has asked you to create a report that shows all incidents opened within the past month.
The report should show the following columns:
• Number of incidents opened in the past month
• Number of incidents opened in the past week
• Number of incidents opened in the past day
Which two functions are needed in the expressions to create the three columns?
A.
NVL
B.
AVG
C.
IF
D.
DECODE
E.
SUM
OK