Please answer the questions for the assignment attached.

Use the ER Diagram on the last page. Write each of the following queries.

i$.$ List the Equipment serial number. List each number only one time.

ii$.$ List the Serial# and Description of all Equipment that has NOT been assigned to any employee. Order the list by Serial#

iii. Assume that all parts have been discounted by $10\%.$ List each Part#$,$ Part Description, Cost, and Discounted$\_$Price for all Parts that originally cost more than $$100\mathrm{.}00.$

iv$.$ List each Date and the number of Repairs that were made on that date.

v$.$ List the ID of the employee that has been assigned the equipment with serial number $111.$

vi$.$ Create the listing of all Repairs that have Invoice# greater than $1845.$ Sort the results by Equipment Serial# descending. Each row in the listing should read:

Repair Invoice Number: Invoice# Problem is: Problem

$**$For example: Repair Invoice Number: $2738$ Problem is: Missing Memory

SELECT CONCAT $(\text{'}$Repair Invoice Number:$\text{'},$ Invoice#$),$ CONCAT $(\text{'}$Problem is:$\text{'},$ Problem$)$

FROM $[$Repair$]$

WHERE Invoice# $>1845$

ORDER BY Serial# DESC;

$**$End of example

vii. List the repair invoice# that occurs before $2014-1-18$ and has a problem with either "Circuit" or "Battery",