FastPrepStudents Scoring Above Average
Problems/Students Scoring Above Average

Students Scoring Above Average

Capstone Investment Advisors logoCapstone Investment Advisors● EasyFULLTIMEOA

Updated Nov 2026

QuestionConstraints

Problem statement

Source note: This Capstone Investment Advisors online assessment had a short SQL task: list the students whose math score is above the class average, sorted by student ID.

The report shows the table, the rule and a full sample, so little is missing. Here, the table and its columns use lowercase names (student, id, name, score). A score equal to the average does not count. The limits are our own, and you can answer in MySQL, PostgreSQL or Pandas.

Our version is about 97% the same as the reported question.

The student table has one row per student. id is the student's unique ID, name is their name, and score is their math score.

Write a query that returns the id and name of every student whose score is higher than the average score of all students. A score equal to the average does not count.

Sort the result by id from smallest to largest.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

student

One row per student with their math score.

ColumnTypeNullableDescription
idPKIntegerNo—
nameTextNo—
scoreDecimalNo—

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
idIntegerNo—
nameTextNo—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

  • The student table has from 1 to 1000 rows.
  • id is unique and 1 <= id <= 10^6.
  • name is one uppercase English letter followed by 0 to 19 lowercase English letters. Names can repeat.
  • 0 <= score <= 100, with at most 2 digits after the decimal point. Scores can repeat.
  • No value is NULL.

More Capstone Investment Advisors Online Assessment questions

  • Capping Portfolio WeightsOA · Seen Nov 2026

Similar questions at other companies

  • Bond Interest Summary Above 3%Wells Fargo · OAWells Fargo interview questions
  • Employee Promotion OpportunitiesIntuit · OAIntuit interview questions
  • Students and Their SubjectsBirla Pivot · OA
  • Companies with Average Salary Above 40000AT&T · OAAT&T interview questions
  • Build Taxi Driver Performance FeaturesBoston Consulting Group · OABoston Consulting Group interview questions
  • Weekend Appointments for Consular Services ReschedulingMcKinsey & Company · OAMcKinsey & Company interview questions
  • Companies Above a Salary ThresholdVerisk · OA
  • Customer Resource Usage AnalysisIBM · OAIBM interview questions
  • Customers Who Never OrderedAccenture · OAAccenture interview questions
  • First Duplicate Transaction Within Ten MinutesLenskart · OA
See Capstone Investment Advisors hiring insights