Initial Codesignal assessment: 14 MCQs and 1 SQL query question. Mini-case interview: A rideshare company wants to expand into a new canadian city XYZ, how would you assess the feasibility? Then I was given some data to assess if the company is profitable? Do the numbers make sense? You realized that insurance is higher than anticipated, what is the contribution margin now? What is your final conclusion? Technical Fit: They give you a schema (1 - 3 tables) and ask you to write queries for: 1) • Tell us• how much • Cash• payments• (total•$) •we • receive each day? 2) • Identify all customers who have more payments • ($) • in cash • than they have electronically? 3) • Identify all customers who have made • over $10,000• in cash • payments during any two day period.
