def show_movie_projections(self, movie_id):
     spots_unavailable = Reservations.show_used_seats_on_each_projection(
         self.__conn)
     avail_sp = {}
     for x in spots_unavailable:
         avail_sp[x['projection_id']] = self.capacity - x['num']
     return {
         "projetions":
         Projections.show_movie_projections_by_movie_id(movie_id),
         "available_spots": avail_sp}