Reached out by recruiter.

Technical screening, 1 hour, 5 Python, 5 SQL. You will be able to see the test cases as you are coding. For SQL questions, you can query the database to check the data.

I got 9.5 out of 10 questions correct. The last SQL question I got incorrect, but the interviewer said my logic looked right. Waiting for response.

Write a function to return the number of times a character appears in a string. The character can be the empty string.

Complete a function that returns a list containing mismatched words in two strings. The return list can be in any order. I used sets to solve this question, but was also asked to verbally explain how I would solve it without using sets.

Given an array containing None values, fill in the array with the most recent non-None value. If the list starts with None, then don't do anything to it.

Given a dictionary, print the key for the nth highest value present in the dictionary. If there are more than one record present for the nth highest value, then sort the keys and print the first one (alphabetically). N can be higher than the number of elements in the dictionary.

Given a list of integers, balance the list so that each integer appears equally in the list. Return a dictionary where the key is the integer and the value is the count needed to balance the list.

• [1, 1, 2] => {2: 1}
• [1, 1, 1, 5, 3, 2, 2] => {5: 2, 3: 2, 2: 1}

What percent of all products in the grocery chain's catalog are both low fat and recyclable?

What are the top five (ranked in decreasing order) single-channel media types that correspond to the most money the grocery chain had spent on its promotional campaigns? media_type can contain multiple values separated by a comma, so single channel is when media_type only has one value.

Percent of sales that had a valid promotion: The VP of marketing wants to know what percent of transactions occur on either the very first day or the very last day of a promotion campaign.

Write a query that returns product_family, units_sold, and percentage_of_promoted.

Write a query that returns the percentage_of_unsold product_category.