Create a function that should display the password of a specific ID from the shopper tableThe function should return the passwords on the basis of corresponding IDs which userinputs during the run time.

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

CREATE FUNCTION get_shopper_password(@id INT)
RETURNS NVARCHAR(50)
AS
BEGIN
    DECLARE @password NVARCHAR(50)
    SELECT @password = Password
    FROM shopper
    WHERE ID = @id
    RETURN @password
END

When a user inputs an ID as a parameter to this function, it will return the corresponding password from the shopper table. Note that this assumes that the `Password` column in the `shopper` table is of type `NVARCHAR(50)`, but you can adjust the type and length of the variable to suit your needs.