Oracle Live SQL and answer the following questions:

3) Create the following table, where EMP_ID is the primary key, and then answer the questions that follow: (2 points) EMP_NAME EMP_ID SALES($) 230823567 1500 Mike Peter Peter Angelo Robert 440876567 921126821 2500 950 810015710 672899012 2500 1950 3.2 Using dense rank() function, remove the gap between Angelo & Robert and rank the employees like this: (1 point) EMP_ID EMP_NAME SALES_RANK 440876567 Peter 1 810015710 Angelo 1 672899012 Robert 2 230823567 Mike 3 921126821 Peter 4 1 1.2 10 11 - 1.12 13.1.14. 1. 15 16 17 18. 3.1 Using the rank() function, produce a table showing the employee id, name, and sales rank like this: (2 points) EMP_ID EMP_NAME SALES_RANK 440876567 Peter 1 810015710 Angelo 1 672899012 Robert 3 230823567 Mike 4 921126821 Peter 5 5