4) Grad Student question: Translate the following query into a RA, and write the original syntax tree and an optimized one (150 points) SELECT hires.Hire_Start, products.prod id, products.title, products.price, product types.name, suppliers.name FROM products INNER JOIN product-suppliers ON products.prod-id = product-suppluer.prod_d INNER JOIN product types ON product types.type_id- products.type id INNER JOIN suppliers ON product suppliers.supp_id-suppliers.supp id INNER JOIN hres ON hres.prod-id = products.prod_d WHERE (hires.hire_end to date('26-JAN-13) GROUP BY products.prod_id, products.title, products.price, product types.name