Guest User

Untitled

a guest
Feb 19th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. select con_date as date, concert_venue as venue, c_title as title
  2. from musician as m, composer as c, has_composed as h, composition as co, performance as p, concert as cn
  3. 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'
  4. group by date;
Add Comment
Please, Sign In to add comment