D. There is an upcoming volunteer AIAD opportunity in East Asia. Write a query t

Question

D. There is an upcoming volunteer AIAD opportunity in East Asia. Write a query that returns the volunteer's last name, company, foreign language knowledge and proficiency for all volunteers that know Chinese, Japanese, or Korean. Sort the output by the foreign language name, then volunteer last name. Your output should look like the partial result below: last name company_id lang_name proficiency Araueta 14 Hundt Woick CesarioH3 Otani E2 Ratiff Fairfax G2 HurtadoE4 Chinese Basic Chinese Basic Chinese Basic JapaneseFluent Japanese Intermediate Japanese Basic Korean KoreanBasic E1 B4 H1 Basic

Explanation / Answer

Select last_name ,company.id,lang_name ,proficiency from volunteer inner join company on volunteer.company_id = company.id inner join volunteer_knows_foreign_language on volunteer.xnumber = volunteer_knows_foreign_language.volunteer_xnumber inner join foreign_language on volunteer_knows_foreign_language.foreign_language_id = foreign_language.id where foreign_language.lang_name IN('Chinese','Japanese','Korean') order by foreign_language.lang_name,volunteer.last_name;

inner join on 4 tables is required

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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