• 1. Find the second highest salary from an Employee table.
  • 2. Find duplicate rows in a table.
  • 3. Write a query to get users who have never uploaded a video (YouTube-style).
  • 4. Find the top 3 most viewed videos.
  • 5. Count how many licenses are active per user (LicenseLane).
  • 6. Fetch users who have more than 1 license.
    1. Write a query to get the latest license expiry date for each user.
    1. Find the nth highest salary (say 3rd).
    1. Write a query to find all users who have at least one expired license.