Database Management Systems, OPPE 2

September 2025 term, 7 Dec 2025, Set A

Quiz Space

MusicOpen the study music controls.

CalculatorOpen the calculatorLearning mode

Question 1

+1−0Instructions

QuestionTest casesSolution

Write an SQL query to find the name of the main Referee who has officiated the match with the highest total score (host_team_score + guest_team_score)

Primary keyForeign key

−100%+Fit

Code Editor

SQL

−14+

ResetNot submitted

Run sample testsSubmit

Submit this paper?

You cannot change your answers after submitting.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

Keep goingSubmit paper

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

• Save & Next moves to the next question. Answers are saved as you go.
• Mark for Review & Next flags the question to come back to. A flagged answer still counts.
• Clear Response removes your answer to the question on screen.
• The ← and → keys move to the previous and next question.

Write an SQL query to find the name of the main Referee who has officiated the match with the highest total score (host_team_score + guest_team_score) Write an SQL query to find the orders that were placed on the most recent date recorded in the database. Display order id and product id only. Find the names of products that are more expensive than the average price of products within their own category.