Exercise9 Create a function that displays the phone number of the recipients of a particular ordernumber from the recipient table. The function should display the phone number of therecipients on the basis of its corresponding order number from the recipient table whichuser inputs during the run time.

Sure, here's an example function in SQL that achieves this:

CREATE FUNCTION get_recipient_phone_number(@order_number INT)
RETURNS NVARCHAR(20)
AS
BEGIN
    DECLARE @phone_number NVARCHAR(20)
    SELECT @phone_number = PhoneNumber
    FROM recipient
    WHERE OrderNumber = @order_number
    RETURN @phone_number
END

When a user inputs an order number as a parameter to this function, it will return the corresponding phone number of the recipient from the recipient table. Note that this assumes that the `PhoneNumber` column in the `recipient` table is of type `NVARCHAR(20)`, but you can adjust the type and length of the variable to suit your needs.