Exercise

CREATE FUNCTIONs

Create three functions to help solve the business case:

Convert distance from miles to kilometers.
Convert currency based on exchange rate parameter.
(These two functions should return a numeric value with precision of 18 and 2 decimal places.)
Identify the driver shift based on the hour parameter value passed.

Instructions 1/3

XP

1
Use CREATE FUNCTION to accept @Miles input parameter & return the distance converted to kilometers.
2
Create a function which accepts @DollarAmt and @ExchangeRate input parameters, multiplies them, and returns the result.
3
Create a function that returns the shift as an integer: 1st shift is 12am to 9am, 2nd is 9am to 5pm, 3rd is 5pm to 12am.