Customers

Figure $1$: Database Schema

Problems

Develop and execute SELECT$-$statements that provide answers to the following questions.

$($a$)$ What are the email addresses of people who have overdue equipment out on loan? Do not use nesting to answer this question.

$($b$)$ What are the email addresses of people who have overdue equipment out on loan? You must use at least one nested query to answer this question.

$($c$)$ What is the average fee for each asset type?

$($d$)$ What persons have assets on loan that were acquired more than two years ago? Show only that person's last name and first name, and order by last name so that persons with a last name starting with $\text{'}A\text{'}$ are listed first and people with last name starting with $\text{'}Z\text{'}$ are listed last.

$($e$)$ What is the average duration of a loan for each asset?