Database Principles... Using MySQL CLI... Submit your answer with code with scre

Question

Database Principles... Using MySQL CLI... Submit your answer with code with screenshot how to do it...

I have already created ERD with 6 Table As Below, I ONLY NEED HELP IN QUESTION 5...

I couldn't get the answer of Question 5.....

PUBLISHER relation Year Name City Country Telephone Founded AUTHOR relation Autho Number Author Name Year Born Year Died BOOK relation Book Number Book Name Publication Year Publisher Nome Pages CUSTOMER relation Customer Customer Number Name Street City State County WRITING relation Book Number Author Number SALE relation FIGURE 5.16 Good Reading Bookstores relational database Book Number Number Customer Date Price Quantity

Explanation / Answer

select c.cumstomer_name
from CUSTOMER c, PUBLISHER p, BOOK b, SALE s
where c.customer_number = s.customer_number
   and s.book_number = b.book_number
   and b.publisher_name = p.publisher_name
   and (p.city = 'New York' or p.city = 'Landon')
      

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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