What are some tricky/clever SQL questions you have faced in the interviews? : SQL

In one of the interviews I was asked to how I’d rank the column values without using Windows function and found it interesting. Any such clever…