---

DELIMITER //

CREATE FUNCTION GetRentalCount(p_device_id INT)
RETURNS INT
READS SQL DATA
BEGIN
    DECLARE rental_count INT DEFAULT 0;
    SELECT COUNT(*)
    INTO rental_count
    FROM rentals
    WHERE device_id = p_device_id;

    RETURN rental_count;
END //

DELIMITER ;