take count(*) as qtd_filmes from filme;

select count(*) set qtd_filmes from filme;

select count(*) into qtd_filmes from filme;

set count(*) to qtd_filmes from filme;

set qtd_filmes = count(*) from filme;