SOLVE

LATER

Student Selection

Problem

Editorial

Analytics

You have been given $$3$$ pieces of Information about the Students studying at XYZ University in the form of a 'Students' Table. The $$3$$ pieces of information include their 'Name','Age' and 'Height'.

Now, there are a total of $$N$$ students studying at the University, where $$N$$ equals the number of rows in the 'Students' table. Now, the University has an Annual Sports day coming up, and for that, they need to select $$3$$ students among the $$N$$ students $$( N \ge 3 ) $$ for the final event.

The University Dean considers the strength of a group of students to be the summation of the heights of all students within the group. Now, the Sports president of the university selects a group of exactly $$3$$ students at random among the $$N$$ students, where the probability of each student being selected for the final event is the same.

Now, you are required to find the Expected Value of the Strength of the group of $$3$$ students selected for the final event. Round of your answer to $$2$$ decimal places.

Can you do it ?

Table : **Students**

Field | Type |
---|---|

Name | text |

Age | int |

Height | int |

Name | Age | Height |
---|---|---|

abcd | 12 | 2 |

efgh | 13 | 2 |

ijkl | 14 | 2 |

answer |
---|

6.00 |

$$ 1 \le N \le 10 $$

$$ 1 \le Age \le 20 $$

$$ 1 \le Height \le 20 $$

Time Limit:
5 sec(s)
for each input file.

Memory Limit:
256 MB

Source Limit:
1024 KB

Marking Scheme:
Marks are awarded when all the testcases pass.

Allowed Languages:
MySQL,
PostgreSQL,
MSSQL,
Oracle_Db

Initializing Code Editor...

{"a648e5b": "/pagelets/suggested-problems/sql/student-selection/", "2da259d": "/pagelets/problem-author-tester/sql/student-selection/", "e3b859e": "/pagelets/show-submission/sql/student-selection/", "2f67829": "/pagelets/recommended-problems/sql/student-selection/", "3810788": "/pagelets/problems-hint/sql/student-selection/"}

realtime.hackerearth.com

80

4da273f844fa93c7185327ac306364be49842fee

58a29e5cae2309f04b28

/realtime/pusher/auth/