Python/sql. Library database joins, ratios, aggregation, involving lots of tables, null values, complex types of joins, window functions. 5 questions in sql and 5 questions in python. Interview was all technical and at a fast pace