Notes/fundamentals
1
0
Fork 0
mirror of https://github.com/robindhole/fundamentals.git synced 2025-03-15 21:20:50 +00:00
Code Issues Packages Projects Releases Wiki Activity
fundamentals/database/notes/08-window-functions-worksheet.md
Tanmay e371662e0d Adds notes.
2022-10-08 16:21:02 +01:00

881 B
Raw Permalink Blame History

Window functions worksheet

  1. Print the student names along with the number of students in their batch.
  1. Print the student names along with the average IQ of their batch.
  1. Print the student names along with the maximum IQ of their batch.
  1. Print the student names along with their rank based on IQ.
  1. Print the student names along with their rank in their batch based on IQ.
  1. Print the student names along with their rank in their batch based on IQ. Ties should not increase the rank.
  1. Print the student names along with their rank in their batch based on IQ. Ties should not be counted and broken by ID.
  1. Find the rank of batches based on the start date of the batch.
  1. Sort the instructors by the first and last name and assign them a roll number.