<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-KVGHS6G" height="0" width="0" style="display:none;visibility:hidden"></iframe>

Square数据相关面试真题

职位分类
全部
数据相关
计算机科学
人工智能
产品经理
BQ
面试题
全部(3)
SQL(0)
Coding(3)
ML basics(0)
Stats(0)
Product Case(0)
高频题(0)
Other(0)
全部(3)
SQL(0)
Coding(3)
ML basics(0)
Stats(0)
Product Case(0)
高频题(0)
Other(0)
1.Find the Entire Request Chain Function
2.Find the Requester Function
3.SQL and Python Technical Screen Questions
1. Find the Entire Request Chain Function
Write a function to find the entire request chain for a given requestee, where the request chain is defined as the sequence of requests leading up to and including the requestee's request. If there are no prior requests, return just the requestee's request.
2. Find the Requester Function
Write a function to find the requester given the requestee. In case there is no requester, return None.
3. SQL and Python Technical Screen Questions
For the SQL part, the question involved basic joins and ranking functions. For the Python part, the task was to write a function to simulate a coin toss game where one player wins by tossing two heads in a row, and the other wins by tossing a head followed by a tail, without the use of additional libraries.