04: (A)-For the following image f and the structuring element b, perform the morphological operation (erosion and dilation) for the shaded pixel. 10

Please use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4)     SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) 12. Display the last name, hire date, and day of the week on which the employee started. Label the columnDAY. Order the results by the week starting with Monday.

Show the sum, average, max, min of student age. For the numbers, provided appropriate field names. Hint: to calculate age, simply use date(‘now’)-DOB

Produce a script file with 15 queries: At least two using join At least three using where clause At least three using order by At least two using single-row functions At least two using group by and group functions at least one nested query At least 4 queries from chapter 1 - 6 (exclude Create Table, Insert queries) ------- TABLE 1 create TABLE ProCoaches(pro_co_ID INTEGER PRIMARY KEY,pro_coachName Varchar(50) NOT NULL,pro_coachLocation Varchar(20)); INSERT INTO ProCoaches VALUES (1, 'John', 'Missoula'); INSERT INTO ProCoaches VALUES (2, 'Joe', 'Bozeman');INSERT INTO ProCoaches VALUES (3, 'Tara','Butte'); select * FROM ProCoaches;select LENGTH('Missoula') AS LengthOfLocation;select pro_coachName FROM ProCoaches where pro_coachLocation='Missoula'; select COUNT(pro_co_ID), pro_coachLocation FROM ProCoaches GROUP BY pro_coachLocation; TABLE 2 create TABLE ProCyclist(pro_cy_ID VARCHAR(10) PRIMARY KEY,pro_cyclist_Name VARCHAR(50) NOT NULL,pro_cyclist_Gender Varchar(20),pro_cyclist_DOB…

List the number of albums for each artist. Only include artists with more than 5 albums. table of database Artist (ArtistId, Name) Album (AlbumId, Title, ArtistId, Year) Track (TrackId, Name, AlbumId, ArtistId, GenreId, Year) Genre (GenreId, Name)