103.Examine the structure of the TRANSACTIONS table:

103.Examine the structure of the TRANSACTIONS table:
name         Null       Type
TRANS_ID     NOT NULL   NUMBER(3)
CUST_NAME               VARCHAR2(30)
TRANS_DATE              DATE
TRANS_AMT               NUMBER(10,2)
You want to display the transaction date and specify whether it is a weekday or weekend.
Evaluate the following two queries:


SQL>SELECT TRANS_DATE,CASE
WHEN TRIM(TO_CHAR(trans_date,'DAY')) IN ('SATURDAY','SUNDAY') THEN 'weekend'
ELSE 'weekday'
END "Day Type"
FROM transactions;


SQL>SELECT TRANS_DATE, CASE
WHEN TO_CHAR(trans_date,'DAY') BETWEEN 'MONDAY' AND 'FRIDAY' THEN 'weekday'
ELSE 'weekend'
END "Day Type"FROM transactions;


Which statement is true regarding the above queries?
A.Both give wrong results.
B.Both give the correct result.
C.Only the first query gives the correct result.
D.Only the second query gives the correct result.
答案:C
解析:第二个使用的是between and，他们其实判断的是ascii，由于F的ascii小雨monday的ascii，
所以BETWEEN 'MONDAY' AND 'FRIDAY'肯定是false，因此第二个sql错误