SQL/MySQL/ORACLE DBA Learning

SELECT name, TO_CHAR(joindate, 'Day') AS dayname, TO_CHAR(joindate, 'Month') AS month,TO_CHAR(join_date, 'YYYY') AS yearofjoining FROM teachers ORDER BY salary DESC;