Challenge yourself with real query exercises.

Examples:

  • Write a query to find students with the highest marks in each subject.
  • Get customers who haven’t placed an order in the last 6 months.
  • Create a stored procedure to calculate discounts based on purchase amount.

( Solutions should require use of JOIN, GROUP BY, CASE, subqueries, etc. )