I am fairly new to Oracle SQL developer and I am having an issue that may very simple but I just cannot work it out logically for some reason.
I am trying to calculate the percentage of sales each employee has made form the total of trades. I have been trying to use the COUNT function but it obviously splits the counts for each employee. I then tried a inline view but couldn't get it to work and also a sub-query and had an issue with "not a single group function" and then "not a GROUP BY expression".
Can anyone tell me how I can do this? I will also need to add the syntax to another inline view I don't know whether that will help.
Thank you in advance