ZS Associates interview question

In tech interview, they first asked on SQL - joins, filtering conditions and window function based queries, then reverse a string pseudocode, python code for first non repeating character in a string, python concepts like == and is, puzzles - water jugs and horse race.