Please use this link to download the database:

https://drive.google.com/drive/folders/11FLfdYZUbIDxLuifwLcZfb9sMxGBnPiI

Part 1) Scalar UDF

Create two Scalar UDFs following the best practices recommend by the textbook author

The TaxRate UDF provides the tax rate based on a ShipCountry and returns a FLOAT value.

If the ShipCountry starts with a letter in the range A-J the tax rate is .04 K-P the tax rate is .03 Q-Z the tax rate is .025

The TaxAmount UDF provides the tax due. It takes two values, a SalesAmount and a TaxRate. The SalesAmount is of the MONEY data type and the TaxRate is of the FLOAT data type. The UDF returns a MONEY value.

Create a query that utilizes the two UDFs to display the total tax on sales by country. I apply the discount when calculating the sales amount. The results should be as shown below

216 45 828 31262 20 52 77 07 06 24 54 -9. 8 4091 1907 2 2 39414 13514 7 dean dg ay bra ca de fri fra ge el al me no po po sp sw sw uk it m n p p s s s u u v 012345678901