I need help on a couple questions here. If someone could show me #3 and #4 examp

Question

I need help on a couple questions here.

If someone could show me #3 and #4 example I think I'll hopefully be able to understand the rest of them. We're just learning subqueries and multi-table queries so just give basic example of each, nothing too crazy or technical I won't be able to understand. We just started learing them a week ago.

Here's the ERD and the questions

http://www.2shared.com/document/SCducQoG/HW6.html?

That is a PDF fiel but it gives the ERD so it should help.

Thank you for the help. I will rate lifesaver if you can help.

Explanation / Answer

SELECT `player`.`playerid`, `gametype`.`time`, ( SELECT `value` FROM ('player`) WHERE `player`.`product` = 'playerid' ) as values FROM (`player`) WHERE`playert`.`active` = 1

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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