Write the SQL to retrieve to retrieve for each appliance submitted for repair its serial number, description, date of sale, the name of the customer who requested the repair, the description of the repair plus the cost of the repair. (JOIN to two tables required). 

Format the output so that it is output in sentences as follows: 

> 
> "The repair to appliance 9001 DVD Player, sold on 1ST JANUARY 2018 to A.GREEN, to solve the issue DVD Stuck will cost €67.50". 
> 
> 
> 

Ensure that zeros are output if no decimal value exists. 

not sure what to use to format the output..searched dbms and print but i'm not really sure if that is what the question is asking for. thanksin advance!

Customer table

```
CUSTID | CUSTNAME | CUSTPHONE | CUSTEMAIL
1001     Aaa        0123        GReen@mail.com
1002     BBB        0121        bbb@mail.com 
1003     CCCC       0333        ccc@mail.com 

```

appRepair table

```
serialNO | RepairDate| RepairDesc| repairCost | Customer_ID
9001       4-Mar-18       0123        67.5          1001
9002       4-JUN-18       0121        60.7          1002
9003       4-AUG-18       0333        102.5         1003

```

appliance table

```
serialNO |    appDESC     | APPSALEDATE | GUARENTEELENGTH 
9001       DVD PLAYER       1-jan-18          2         
9002       FRIDGE FREEZER   3-may-18          5         
9003       48 TV            5-jun-18          2       

```

My code for the select query 

```
select appliance.serialNo, appliance.appDesc, TO_CHAR(appliance.appSaleDate, 'DDTH MONTH YY') AS "SALE DATE", 
UPPER(Customer.custName) AS "CUSTOMER NAME", Customer.custEmail from appliance 
inner join appRepair ON appliance.serialNo=appRepair.serialNo
inner join Customer ON appRepair.customer_id=Customer.custID;

```

expected output : 

> 
> "The repair to appliance 9001 DVD Player, sold on 1ST JANUARY 2018 to A.GREEN, to solve the issue DVD Stuck will cost €67.50".
> 
> 
>