Question

Write a query to display list of staff name, subject name handled, maximum mark scored in that subject. Give an alias to the maximum mark as max_mark. Sort the result based on maximum mark in descending
using:joins & subquery

Answer 1

Below is the answer to your question