Hi guys,
I got some issue on selection statement in grid.
My business context is for some training bootcamp, the training school offer 3 licence level : platinum (highest) - gold (middle) - silver
Student got to choose many courses, some courses are Platinum, Gold or Silver.
In fact, if student choose one course only in all his choices with Platinum licence level (even the other are all Gold or Silver) the final licence level to pay will be Platinum and so on.
Number | Courses | Licence level
1 | Machine Learning | Gold
2 | Deep Learning | Platinum
3 | Data analyze | Silver
5 | Reinforcement Learning | Platinum
The grid will look like this one.
How could i work with select statement or another way to filter to keep only the highest level for each student ?
Thanksfully.