Company: Adobe
Difficulty: easy
The Math scores of students have been stored in the STUDENT table. Write a query to print the ID s and the NAME s of the students who have secured higher than the average score . The result should be sorted in ascending order of student ID. Table Description STUDENT Name Type Description ID Integer unique ID, the primary key NAME String student name SCORE Float the Math score of the student Input Format (for the code runner) The table is provided on standard input as plain text: STUDENT: ID NAME SCORE <id> <name> <score> ... one row per line ... The first two lines are the table marker and the column header. Every following line holds one row. Names contain no spaces, and rows are not necessarily given in ID order. Output Format Print one line per qualifying student containing its ID and NAME separated by a single space, in ascending order of ID . If no student scored higher than the average, print nothing. Constraints 1 ≤ number of rows ≤ 1000 1 ≤ ID ≤ 10