Q#36: Assigning grades

You are given a dataframe (called df) of students, and you need to assign grades to each student. The table schema is…

Q#35: Christmas M&Ms

Suppose you have two different bags of M&Ms, one is a special Christmas edition while the other is a standard bag of M&Ms…

Q#32: Fraudulent Retail Accounts

Below is a daily table for an active acount at Shopify (an online ecommerce, retail platform). The…

Q#37: Rolling to win!

Suppose you are playing a game with a fair die (e.g. no bias for any one side), and your expected payout based on the #…

Q#34: Counting the distance between words in Python

Q#31: Rolling 9s for $50

Suppose you are playing a game where there are two fair six-sided dice, and every time you roll the dice and they…

Q#29: Filtering grades based on city avg, in SQL

Q#33: Querying San Francisco Public Worker Salary

Q#38: Lifetime of a customer

Suppose you work for a large eCommerce company. You’re given the below table schema for a table called…

Q#30: Oh foo-ie!

Write a function that takes in an integer n, and prints out integers from 1 to n inclusive.