mirror of
https://github.com/robindhole/fundamentals.git
synced 2025-03-15 21:20:50 +00:00
881 B
881 B
Window functions worksheet
- Print the student names along with the number of students in their batch.
- Print the student names along with the average IQ of their batch.
- Print the student names along with the maximum IQ of their batch.
- Print the student names along with their rank based on IQ.
- Print the student names along with their rank in their batch based on IQ.
- Print the student names along with their rank in their batch based on IQ. Ties should not increase the rank.
- Print the student names along with their rank in their batch based on IQ. Ties should not be counted and broken by ID.
- Find the rank of batches based on the start date of the batch.
- Sort the instructors by the first and last name and assign them a roll number.