1. Write an SQL stored procedure to upsert data into a table.
2. How would you calculate the annual units of shoes sold using the provided data (population, number of users, pairs sold per month)?
3. Write SQL queries for basic joins.
4. Write a function to find repeated characters in a string.
5. Write a few code examples in Python.