USING SQL!! lets find mechanics with more than five certifications so we can giv

Question

USING SQL!! lets find mechanics with more than five certifications so we can give them a raise

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

mechanics with total number of certificates can be listed as follows:

select count(emp_id) from mechanic_certs;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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