$(20$ points$)$

The following dessert schema, has the relations:

Actor $($aID$,$ IName, fName, rating, age$)$

Performs$(()$

Show $($sID$,$ sName, sLocation$)$

Where Performs.aID references Actor.aID and Peforms,sID references Show.sID The key attributes are underlined in each relation.

Using the following SQL query, answer the questions that follow$($create $4$ separate drawings$)$:

SELECT A$.$fName, A$.$lName, S$.$sName

FROM Actor A$,$ Show S$,$ Performs P

WHERE A$.$aID $=$ P$.$aID AND S$.$sID $=$ P$.$sID;

AND P$.$role $=$ 'Simba' AND S$.$sLocation $=$ 'Miami';