I have a simple set of player scores in a table that I am trying to place into a view named "view_Team"
The table mainly consists of columns
- Team Name
I have this working to calculate these in a view named "view_calc_avg" to give "Total Score" and "Avg Score".
What I need is a view that will give total and avg on a team bases by date.
What I have now only gives 1 line of output that sums every date data together?
This does not work.....
I am using phpMyAdmin version 4.6.6
If anyone can help I would appreciate it!
Thanks in advance..