USING SQL PLUS WRITE A QUERY THAT WILL FIND THE BUSIEST STORE LAST YEAR (QUANTIT

Question

USING SQL PLUS WRITE A QUERY THAT WILL FIND THE BUSIEST STORE LAST YEAR (QUANTITY OF APPTS). BE SURE TO JOIN ALL THE TABLES REFERENCED SO AS TO AVOID A CARTESIAN PRODUCT.

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 empid,count(*) as counting from employeetable
where empid in ('p','a')
group by empid

take a table, table name : Attendance
_____________________________________________
| EmpID | Month | Day1| Day2| Day3|

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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