| Name | School | city | Flag_class12 | Flag_class10 | Score | Header 7 |
|---|
| ram | ABC | delhi | 1 | 0 | 78 | |
| mohan | ABC | delhi | 0 | 1 | 62 | |
| ravi | DEF | Mumbai | 0 | 0 | 56 | |
| ramesh | GHI | Mumabi | 1 | 0 | 48 | |
large data only sample is shown here .
Raw data is as shown above: Flag_class12 :if student is in class 12 then 1 otherwise 0, similarly for Flag_class10.
we need to create a view with following options in output.
these are used to filter data on basis of city and school, now I need to invite some student to a event , user will enter then number,
and how many 12th students and how many 1th student must come, based on their scores
| Total Students |
|---|
| user enter value |
| Class 12th |
|---|
| How many 12 th class student in percentage entered by used |
| Class 10 th |
|---|
| How many 10 th class student in percentage entered by use |
Rest student based on scores:
output required :
| Student Name | Student class |
|---|
| |
| |
| |
| |
Ex: suppose user select total students as 100, and 12th class as 20% and 10 th class as 40% then
in final table we require 20 12th student , then 40th student and rest 40 other students.
how can we create the last table with student name and class ??
