Table Employee

fname text,

Iname text,

dob

date,

Table Skill

skillcode numeric,

skillname text

salary numeric,

skillcode numeric

DO NOT USE JOINS. You have to use subqueries where needed. Do not use codes in your search criteria.

Identify each of your answers with the corresponding number associated with the question.

Display the first and last name of all employees whose salary is less than the average salary,

$1$ are Electricians and are older than $25$ years old. $($You have to search the skillname column for Electricians$)$ If the last name is null display $"$no last name". Also, keep in mind that dob is a date datatype.

$2$ Display the average salary of employees who are programmers $($regardless of case$).($You have to search the skillname column for programmer $($regardless of case$))$

Create a table called employee $2$ that contains all the employees who are electricians and

$3$ whose last name ends with an $h$ regardless of case. $($You have to search the skillname column for electricians$)$ The new table should only contain the columns fname, Iname and salary$/2$

$4$ Display the employee first name and the text "rich" if the worker is making more than $70000$ otherwise display "poor".

Display the skillcode and the number of people for each skill. In your count, include only the $5$ employees who are older than $35$ years old. $($Keep in mind that you have to convert dob to age$)$

$6$ Display the employee first name and the text "unemployed" if the person is not associated with any skill otherwise display the employee first name and the text "employed"