[EvroStandart]

Так нужно два разных дня, а не два раза?

запрос show_day:
SELECT DISTINCT ShowTimes.Theatre, ShowTimes.Title, ShowTimes.Day
FROM ShowTimes;

запрос how_much_day:
SELECT show_day.Theatre, show_day.Title, Count(show_day.Theatre) AS c_count
FROM show_day
GROUP BY show_day.Theatre, show_day.Title
HAVING (((Count(show_day.Theatre))>=2));