I have a MySQl table which holds performance result data.
ASales_Actual, ASales_Target, BSales_Actual, BSales_Target, Name, Team
I need to write a select statement which will show the person who has sold the most in terms of highest percentage reached of their target. I don’t know how to do this.
I am able to select the person who has sold the most units using sum()
Can someone please help me with who I can select the highest in terms of percentage reached please?