MySQL stored procedures reference

DELIMITER //
CREATE PROCEDURE get_all_cars()
BEGIN
    SELECT * FROM cars ORDER BY make, value DESC;
END //
DELIMITER ;

DELIMITER //
CREATE PROCEDURE get_cars_by_year(
    IN year_filter int
)
BEGIN
    SELECT * FROM cars WHERE year = year_filter ORDER BY make, value DESC;
END //
DELIMITER ;

DELIMITER //  
  
CREATE PROCEDURE add_admin_user(IN company_id INT, IN user_id INT)  
BEGIN  
    DECLARE company_user_id INT;  
  
    -- Add company user  
    INSERT INTO company_user(company_id, user_id, notify)  
    VALUES (company_id, user_id, 1);  
  
    -- Get the ID of the company user just added  
    SELECT LAST_INSERT_ID() INTO company_user_id;  
  
    -- Make user an admin user  
    INSERT INTO company_user_role(company_user_id, role_id)  
    VALUES (company_user_id, 2);  
  
    INSERT INTO company_user_role_selected(company_user_id, role_id)  
    VALUES (company_user_id, 2);  
END //  
  
DELIMITER ;

DELIMITER //
CREATE PROCEDURE get_car_stats_by_year(
    IN year_filter int,
    OUT cars_number int,
    OUT min_value decimal(10, 2),
    OUT avg_value decimal(10, 2),
    OUT max_value decimal(10, 2)
)
BEGIN
    SELECT COUNT(*), MIN(value), AVG(value), MAX(value)
    INTO cars_number, min_value, avg_value, max_value
    FROM cars
    WHERE year = year_filter ORDER BY make, value DESC;
END //
DELIMITER ;

CALL get_all_cars()

DROP PROCEDURE get_car_stats_by_year;