employee

employee is a database table containing employee details whose create DDL is given below. Write the SQL to list the name and designation of…