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.