Is there an IF statement that I can use in an Oracle SQL statement.
Week1 = If orderdate between A and B Then qty, else 0
Week2 = If orderdate between C and D then qty, else 0
and so forth...
Any help would be greatly appreciated...