PracHub
QuestionsPremiumCoachesLearningGuidesInterview Prep
|Home/Data Manipulation (SQL/Python)/IBM

Write SQL to compute max and min marks

Last updated: Mar 29, 2026

Quick Overview

This question evaluates a candidate's ability to perform basic data aggregation in SQL, specifically computing summary statistics from a single table. It is commonly asked to assess competence in data manipulation and query result shaping within the Data Manipulation (SQL/Python) domain, focusing on practical application of SQL aggregation rather than purely conceptual theory.

  • easy
  • IBM
  • Data Manipulation (SQL/Python)
  • Data Scientist

Write SQL to compute max and min marks

Company: IBM

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Take-home Project

## Tables ### `marks` | column | type | notes | |---|---|---| | student_id | INT | primary key | | marks | INT | not null | ## Task Write a SQL query that returns a **single row** with: - `max_marks`: the maximum value of `marks` - `min_marks`: the minimum value of `marks` ### Output A single row with columns `(max_marks, min_marks)`.

Quick Answer: This question evaluates a candidate's ability to perform basic data aggregation in SQL, specifically computing summary statistics from a single table. It is commonly asked to assess competence in data manipulation and query result shaping within the Data Manipulation (SQL/Python) domain, focusing on practical application of SQL aggregation rather than purely conceptual theory.

IBM logo
IBM
Oct 3, 2025, 12:00 AM
Data Scientist
Take-home Project
Data Manipulation (SQL/Python)
3
0

Tables

marks

columntypenotes
student_idINTprimary key
marksINTnot null

Task

Write a SQL query that returns a single row with:

  • max_marks : the maximum value of marks
  • min_marks : the minimum value of marks

Output

A single row with columns (max_marks, min_marks).

Submit Your Answer

Sign in to leave a comment

Loading comments...

Browse More Questions

More Data Manipulation (SQL/Python)•More IBM•More Data Scientist•IBM Data Scientist•IBM Data Manipulation (SQL/Python)•Data Scientist Data Manipulation (SQL/Python)
PracHub

Master your tech interviews with 8,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.