SOLVE

LATER

Vanya and Students

Problem

Editorial

Analytics

Vanya is a Competitive Programming teacher at Berland International School, and she needs to prepare an end-semester report for each of the students studying in her class.

Each of the students of her class gave $$3$$ papers, one in Algorithms, one in Math, and one in Data-structures. Each paper has a maximum of $$40$$ marks, and the minimum score to pass a single paper is $$10$$.

Now, she knows that each student of her class has passed in all $$3$$ papers, She has been given the 'Name' , 'ID' and 'Total' of each student. Now, the following problem comes to her mind :

What is the maximum number of students that may have obtained atleast $$15$$ marks in atleast $$2$$ papers?

She being a busy woman, wants you to help her with this, so that she can solve some problems during this time. Can you do it?

For better understanding of the problem, refer to the sample explanation given below.

Table : **Students**

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

Name | text |

ID | text |

total | int |

**Sample Students table**

Name | ID | Total |
---|---|---|

Micro | 12abcd | 39 |

Vanya | 13abcd | 31 |

Rhezo | 14abcd | 41 |

Count |
---|

1 |

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 Database

Initializing Code Editor...

{"333616d": "/pagelets/problems-hint/sql/micro-and-students/", "3336128": "/pagelets/suggested-problems/sql/micro-and-students/", "3336182": "/pagelets/recommended-problems/sql/micro-and-students/", "3336108": "/pagelets/show-submission/sql/micro-and-students/", "3336155": "/pagelets/problem-author-tester/sql/micro-and-students/"}

{}

realtime.hackerearth.com

80

61dcb350c9e7fcbe5546019e66a7a4404589ae4d

58a29e5cae2309f04b28

/realtime/pusher/auth/