037 Radojevic Petar

1.
SELECT last_name AS "Last name", TO_CHAR(birthdate, 'Month fmDD, YYYY') AS "Birthdate"
FROM f_staffs
WHERE birthdate>='01-Dec-1970'

2.
SELECT id , first_name AS "Name",  TO_CHAR(salary, '$9999.99') AS "Salary"
FROM f_staffs

3.
SELECT name AS "Name", TO_CHAR(NVL2(end_date, ADD_MONTHS(SYSDATE, 2), SYSDATE), 'DD.MM.YYYY') AS "Date"
FROM f_promotional_menus

4.
SELECT last_name AS "Last name", NVL(TO_CHAR(overtime_rate, '$9999.99'), '$0.00') AS "Overtime status"
FROM f_staffs