Write SQL to compute max and min marks

Q: Write SQL to compute max and min marks

This is a Data Manipulation (SQL/Python) interview question from IBM for Data Scientist roles. View the full question and solution on PracHub.

Q: How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

Question

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).

Write SQL to compute max and min marks

Tables

marks

Task

Output

Comments (0)

`marks`