ALTER PROCEDURE Otchet1
	@Param1 DATE,
	@Param2 DATE
SELECT NAME_FILM
FROM Film,Afisha
WHERE (Afisha.FK_FILM=Film.ID_FILM) AND (Afisha.DATA_POKAZ BETWEEN @Param1 AND @Param2)
END



ALTER PROCEDURE Otchet2
	@Param1 INT,
SELECT NAME_FILM, NAME_PROIZV
FROM Film,Proizvoditel
WHERE (@Param1=Zhanr.FK_ZH) AND (Proizvoditel.ID_PROIZV=Film.FK_PR);
END