Database Sql (Check images for tables)

For each task, choose whether a single-row or multiple row function would be most appropriate:

(a) Showing all of the email addresses in upper case letters

(b) Determining the average salary for the employees in the sales department

(c) Showing hire dates with the month spelled out (September 1, 2004)

(d) Finding out the employees in each department that had the most seniority (the earliest hire date)

(e) Displaying the employees salaries rounded to the hundreds place

(f) Substituting zeros for null values when displaying employee commissions

DEPARTMENI_ID NOMBER (4) SELECT FROM EMPLOYEES