PRACTICE EXERCISES

Write queries for the following by using the Corporation database.

$1.$ Display all employees with their commission value. Display $0$ commission for employees who do not get any commission.

$2.$ Count the total number of employees.

$3.$ Count the distinct relation names in DEPENDENT table.

$4.$ Display all employee names and hire dates. Display hire dates with the format $\text{'}20$ OCTOBER. $1970\text{'}.$

$5.$ Find the average, highest, and lowest employment years for employees.

$6.$ Display the total number of dependents for each employee for employees who have at least two dependents.

$7.$ Find average employee commission.

a$)$ Ignore nulls.

b$)$ Do not ignore nulls.