What are the studio name and studio address of the studio whose executive has th

Question

What are the studio name and studio address of the studio whose executive has the highest executive_net_worth?

What are the studio name and studio address of the studio whose executive has the hiqhest Executive Net Worth? Hovies MovieExecutive Executive ID Executive Name Executive Address Executive Net Worth Invest StarsIn Title Y ear Star Name Have oo Title Y ear Length Type Studio Name Executive ID Owns Act In Produce Studio Studio Name Studio Address Executive ID MovieStar Star Name Star Address Gender Birthdate

Explanation / Answer

You can write SQL query for the question as given below :

- First you have to join two entities studio and MovieExecutive.

- Then find executive with highest net worth.

- Return studio information depending on result of highest net worth.

SQL query :

select studio.studio_Name, studio.studio_Address

from studio

inner join MovieExecutive

where MovieExecutive.Executive_Net_Worth in(

select max(Executive_Net_Worth)

from MovieExecutive

);

if you have any doubts then you can ask in comment section.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.