The salary analysis information you provided in question is helpful; however, the company would like to add to their analysis. They would like to know the average salary of employees in departments that have more than 2 employees. Write a query using the AVG function to provide this information. Your results should display the name of the department, the minimum salary of the department as "Dept Min", the maximum salary as "Dept Max", and the average salary as "Dept Avg". Format the salaries as currency. Sort your results by the department name.

Small Company ERD EMP_DETAILS_VIEW JOBS EMPLOYEES BOOK_CATEGORY NUMBER (6) P EMPLOYEE_ID * JOB_ID VARCHAR2 (10) * EMPLOYEE_ID NUMBER (6 BOOK_CATEGORY_CD CHAR (2) JOB_TITLE VARCHAR2 (35) JOB_TITLE VARCHAR2 (35) FIRST_NAME VARCHAR2 (20) BOOK_CATEGORY_NAME VARCHAR2 (100) MANAGER_ID NUMBER (6) MIN_SALARY NUMBER (6 LAST_NAME VARCHAR2 (25) BOOK_CATEGORY_DESCRIPTION VARCHAR2 (2000) DEPARTMENT_NAME VARCHAR2 (30) MAX_SALARY NUMBER (6) EMAIL VARCHAR2 (25) PK_BOOK_CATEGORY (BOOK_CATEGORY_CD) FIRST_NAME VARCHAR2 (20) PHONE_NUMBER VARCHAR2 (20) LAST_NAME VARCHAR2 (25) _JOBS (JOB_ID) * HIRE_DATE DATE SALARY NUMBER (8,2) JOB_HISTORY JOB_ID VARCHAR2 (10) COMMISSION_PCT NUMBER (2,2) AP * EMPLOYEE_ID NUMBER (6) SALARY NUMBER (8,2) EMPLOYEES p START_DATE DATE COMMISSION_PCT NUMBER (2,2 * END_DATE DATE MANAGER_ID NUMBER (6) DEPARTMENTS DEPARTMENT_ID NUMBER (4) JOBS F * JOB_ID VARCHAR2 (10) DEPARTMENT_ID NUMBER (4) BONUS VARCHAR2 (5) CPK_JOB_HISTORY (EMPLOYEE_ID, START_DATE) PK_EMPLOYEES (EMPLOYEE_ID) UK_EMP_EMAIL (EMAIL) FK_JOB_HIST_DEPT (DEPARTMENT_ID) FK_JOB_HIST_JOB (JOB_ID) 3FK_EMP_DEPT (DEPARTMENT_ID) FK_EMP_JOB (JOB_ID) IX_JOB_HIST_DEPT (DEPARTMENT_ID) FK_EMP_MGR (MANAGER_ID) REGIONS DEPARTMENTS BOOKS Ko IX_JOB_HIST_EMP (EMPLOYEE_ID) IX_EMP_DEPT (DEPARTMENT_ID) * BOOK_ID NUMBER (6 P REGION_ID NUMBER * DEPARTMENT_ID NUMBER (4) IX_JOB_HIST_JOB (JOB_ID) REGION_NAME DEPARTMENT_NAME JOB (JOB_I BOOK_TITLE VARCHAR2 (250) VARCHAR2 (25) VARCHAR2 (30) NUMBER (6 IX_EMP_MGR (MANAGER_ID) BOOK_DESCRIPTION VARCHAR2 (2000) MANAGER_ID PK_REG_ID (REGION_ID) NUMBER (4 IX_EMP_NAM (LAST_NAME, FIRST_NAME) BOOK_CATEGORY_CD CHAR (2) LOCATION_ID BOOK_PRICE NUMBER (8,2) PK_DEPT (DEPARTMENT_ID BOOK_REVIEWS NUMBER (5) 3FK_DEPT_LOC (LOCATION_ID USER_RATING NUMBER (2, 1) FK_DEPT_MGR (MANAGER_ID) PK_BOOKS (BOOK_ID IX_DEPT_LOCATION (LOCATION_ID) FK_BOOK_BOOK_CAT (BOOK_CATEGORY_CD) V ORDER_ITEMS COUNTRIES LOCATIONS CUSTOMERS ORDERS ORDER_NBR NUMBER (12) ORDER_ITEM_ID NUMBER (20) P COUNTRY_ID CHAR (2) LOCATION_ID NUMBER (4) CUSTOMER_IC NUMBER (6) P UF* ORDER_NBR NUMBER (12) COUNTRY_NAME VARCHAR2 (40) STREET_ADDRESS VARCHAR2 (40) FIRST_NAME VARCHAR2 (25) CUSTOMER_ID NUMBER ( 6 ) TIMESTAMP UF* BOOK_ID NUMBER (6) REGION_ID NUMBER POSTAL_CODE VARCHAR2 (12) * LAST_NAME VARCHAR2 (25) ORDER_DATE CITY VARCHAR2 (30) * STREET_ADDRESS VARCHAR2 (50) ORDER_TOTAL NUMBER (8,2) UNIT_PRICE NUMBER (8,2) PK_COUNTRY_C_ID (COUNTRY_ID) STATE_PROVINCE VARCHAR2 (25) CITY VARCHAR2 (50) SALESPERSON_ID NUMBER (6) QUANTITY NUMBER (8) FK_COUNTR_REG (REGION_ID) KF COUNTRY_ID CHAR (2) * STATE VARCHAR2 (50) KE PK_ORDER_ITEMS (ORDER_ITEM_ID ZIP_CODE VARCHAR2 (10) KE PK_ORDERS (ORDER_NBR) PK_LOC_ID (LOCATION_ID) UK_ORD_ITM (ORDER_NBR, BOOK_ID) COUNTRY CHAR (50) FK_ORD_CUST (CUSTOMER_ID) FK_LOC_C_ID (COUNTRY_ID) PHONE_NUMBER CHAR2 (25 FK_ORD_EMP (SALESPERSON_ID) FK_ORD_ITM_ORD (ORDER_NBR) VARCHAR2 (50) IX_LOC_CITY (CITY) EMAIL FK_ORD_ITM_PROD (BOOK_ID) IX_LOC_COUNTRY (COUNTRY_ID) DATE_OF_BIRTH DATE IX_LOC_STATE_PROVINCE (STATE_PROVINCE) GENDER VARCHAR2 (1) PK_CUSTOMERS (CUSTOMER_ID)