I want to know how we do this formula on SQL
enter image description here
Example, there are 2 Name A & B, Each Group have 1,2,3,… division, Each division have value
- First step: Average Value by Division (it might be have more than 1 value)
- Second step: Average Value by Group (Division1,Division2,……)
- Third step: Average Value by Name (Group1,Group2,….)
Any help will be appreciated.
New contributor
Aldo Putra Setia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2