I have a report that i imported into access and need a query that displays the top 25% of users based on their usage which is times run. I then these users average duration based on their (total duration/times run) and then divided by 60 so i can get the total hours.
Providing me the SQL would be helpful since i am learning this coding and obtaining concrete examples help.
Attached is spreadsheet that provides the data and output i require. Dragon1.xls
User35 has run 78 times not 350, and User4 has run 224 times not 369.