bp Interview Question

1.5 hour of technical assessment round Data mining , python , SQL codes to write. Like find nth highest value from column.