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.

Write SQL to compute max and min marks

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

Oct 3, 2025, 12:00 AM

Data Scientist

Take-home Project

Data Manipulation (SQL/Python)

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

Comments (0)

Loading comments...