Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select con_date as date, concert_venue as venue, c_title as title
- from musician as m, composer as c, has_composed as h, composition as co, performance as p, concert as cn
- where m.m_no=c.comp_is and c.comp_no=h.cmpr_no and h.cmpn_no=co.c_no and co.c_no=p.performed and p.performed_in=concert_no and m.m_name='Andy Jones'
- group by date;
Add Comment
Please, Sign In to add comment