CREATE OR REPLACE FUNCTION get_jew_name_by_shop_id(id INT)
RETURNS TABLE(jewel_name VARCHAR(50), shop_id INT)
AS $BODY$
    SELECT jew_name, shop_id FROM jewels WHERE shop_id = id;
$BODY$ language sql;


CREATE PROCEDURE add_shop(name varchar(60))
LANGUAGE SQL
AS $$
INSERT INTO shops(shop_name) VALUES (name);
$$;