Keller Williams interview question

1 sql questions on case statement and 1 python statement on applications of binary search