Database: movie_2
Question: How many distinct movies are on in theaters?
SQL:
SELECT count(DISTINCT T1.code) FROM movies AS T1 JOIN movietheaters AS T2 ON T1.code  =  T2.movie