12.00.d.   Write the SQL Command which would produce the following Output:

 

Dancer                                          Date Danced

-------------------------------------------------- ---------

Makarova                                    29-MAY-2013 (Oracle)

Farrell                                           15-JUN-2013 (Oracle) 

 

select dancer_name as "Dancer", dancedate as "Date Danced"

from dancer, ballet, role

where ballet_Name = 'Romeo and Juliet'

and rolename = 'Juliet'

and dancernum = dancer_number

and balletname = ballet_name;

 

Dancer Date Danced
Makarova 5/29/2013
Farrell 6/15/2013