Data Model:
LinkedIn data model - model for 1st degree connection
Python:
1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion)
2. Find the number of words in a sentence /avg length of word
SQL
On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries
1. Count of stores in OR state with area_sqft > 25000
2. avg number of Female Customers group by state
3. Customer FirstName, Last Name and count of unqiue products purchased by state
followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))
