Python Questions:
Avg length of words, some of the edge cases are having spaces in the beginning and end of the words, returning a float instead of int, returning None for blank input.
Valid ip address, edge case to remember is if there are alphanumeric characters.
SQL questions:
One SQL question was tricky because you have to look at the data to come up with the question, the question is to find the percent of valid promotion, condition to find valid promotion is not specified in the question, so you have to figure it from looking at the data.
Other SQL questions are based on a join, group by, top(3)