We use Phpmyadmin for this assignment Phase 9 -Subqueries Step 1-Write a subquer

Question

We use Phpmyadmin for this assignment

Phase 9 -Subqueries Step 1-Write a subquery that displays the name and university from the PEOPLE table where that person attending a university with an acceptance rate of less than 10% Step 2 - Write a subquery that displays the name and university from the PEOPLE table where that person attends a university in New York, NY.. Step 3- Write a subquery that displays the name, occupation, and university of any person who went to a university that had a less than 10% acceptance rate, as well as a tuition below $50,000 per year.

Explanation / Answer

Solution:

PHPMYADMIN uses MySQL, so the answer is according to that.

Note: The schema is not given in the question, so I have provided the queries as per the assumption of the attributes.

Step-1:

Subquery:

SELECT university_name FROM PEOPLE WHERE acceptance_rate= '10%'

Step-2:

Subquery:

SELECT name, university_name FROM PEOPLE WHERE city= 'NY'

Step-3:

Subquery:

SELECT name, occupation, university_name FROM PEOPLE WHERE acceptance_rate<'10%' AND tution_price <50000

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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