SELECT sale_person_id, max(no_products_sold) as max_sold, link(sale_person_name, max_sold), FROM sales_department_details I'm

SELECT sale_person_id, max(no_products_sold) as max_sold, link(sale_person_name, max_sold), FROM sales_department_details I'm not sure what `link` is supposed to be, but wouldn't the dream syntax modification to SQL simply be SELECT sale_person_id, no_products_sold as max_sold, sale_person_name, commission_percentage, sales_department, FROM sales_department_details GROUP BY sale_person_id WHERE no_products_sold = max(no_products_sold)