Salesforce SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 9905)

[@VusaMate2]

Could you solve more hard questions

[@frederikmuller]

yep, on it. will keep uploading some medium ones for beginners, as well.

[@Peter-xu5nz]

Would this work for the Max function? Rechecked the solution and is it because MAX not in the subquery would just return only 1 employee name? Thanks!
SELECT
first_name,
MAX(target) as highest_target
FROM salesforce_employees
WHERE manager_id = 13

[@jermitgunning2346]

You would need a group by expression