ちゃーむずが共演したイベントの一覧

charms.sql

WITH q AS (
     SELECT count(e.event_id),e.event_id,e.name,e.start_time
     FROM event e,actor a,performer p
     WHERE ( a.name='永野愛理' OR a.name='山下七海' )
       AND e.event_id=p.event_id
       AND p.person_id=a.actor_id
     GROUP BY e.event_id )
SELECT * FROM q WHERE count=2 ORDER BY q.start_time;