Using the same database bbelow, lets find our most loyal customer (quantity of a

Question

Using the same database bbelow, lets find our most loyal customer (quantity of appts) so that we can award them a free service. MAKE A SQL QUERY TO FIND THIS PLEASE

shop(location num, address, no_of_bays, phone, fax) employee(emp id. location num, home_address, wage, is_hourly, date_of_hire) admin(emp id, position) mechanic(emp id, years_exp) mechanic certs(emp id, cert ore, cert name) mechanic appt(emp id. appt no) service appt(appt no, is_completed, date_time,type) auto_appt(appt_no, vin) auto(vin. cust no. year, type, engine, transmission) customer(cust no, name, address, phone_l, phone_2)

Explanation / Answer

select customer.name from customer where cust_no like

(select auto.cust_no from auto, auto_appt where auto.vin = auto_appt.vin);

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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