Home /
Expert Answers /
Computer Science /
describe-what-each-of-the-following-sql-statements-represent-in-plain-english-2-i-hint-leave-di-pa884
(Solved): Describe what each of the following SQL statements represent in
plain English.
2.i) (hint) leave di ...
Describe what each of the following SQL statements represent in
plain English.
2.i) (hint) leave distinct out, execute, then add it back in and execute to see what it's doing. seloct distinct product_department, employee_firstname \( F,+ \) + employee_lastname as department_manager, vendor_name as department_vendor, vendor_phone as department_vendor_phone from fudgemart_employees join fudgemart_departments_lookup on employee_department = department_id join fudgemart_products on product_department = department_id join fudgemart_vendors on product_vendor_id=vendor_id where employee_jobtitle='Department Manager'