Q1. Please write SQL codes to query data from member tables based on below criteria
Please write a SELECT statement to display each member data that street must NOT be ‘STREET’ and ‘LANE’, and valid_date CANNOT be ‘FEB’, ‘APR’, and ‘JUN’. Please display the result in descending order of the last_name. The result should be identical to below results:
[SCREENSHOT]
I try to use this, but it gives me this error:
SELECT MEMBER_ID, FIRST_NAME, LAST_NAME, STREET, FORMAT(VALID_DATE, 'dd-MM--yy')
FROM MEMBER
WHERE STREET NOT IN ('STREET', 'LANE')
AND MONTH(VALID_DATE) NOT IN (2, 4, 6)
ORDER BY LAST_NAME DESC;
====== error =====
ORA-00904: "MONTH": invalid identifier
ORA-00904: "FORMAT": invalid identifier
Extracted text: MEMBER ID FIRST NAME LAST NAME STREET VALID DAT | 110 JACK WHITE 123 ΜΑΙΝ ROAD 01-JAN-99 114 JACK RED 123 LΥNN ROAD 01-MAY-99 118 JACK GRAY 123 JONE ROAD 01-SEP-99 116 JACK CRIMSON 123 JAY ROAD 01-JUL-99 112 JACK BLUE 123 CREE ROAD 01-MAR-99