CREATE OR REPLACE PROCEDURE 
    AverageSalary
BEGIN
    SELECT 
        AVG( salary ) AS average_salary
    FROM 
        vacancy
    WHERE 
        start_date >= DATE_SUB( NOW(), INTERVAL 1 MONTH )
    ;
END