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

Realtor.com数据相关面试真题

职位分类
全部
数据相关
计算机科学
人工智能
产品经理
BQ
面试题
全部(2)
SQL(1)
Coding(0)
ML basics(0)
Stats(0)
Product Case(1)
高频题(0)
Other(0)
全部(2)
SQL(1)
Coding(0)
ML basics(0)
Stats(0)
Product Case(1)
高频题(0)
Other(0)
1.Determine high-value leads from limited information
2.Write a SQL query to pick the most recent lead submission of each user
1. Determine high-value leads from limited information
Given a table with columns 'date', 'user_id', 'lead_id', 'listing_price', and considering that one user can submit multiple leads, how would you determine which are the high-value leads using only the information provided in the table?
2. Write a SQL query to pick the most recent lead submission of each user
Given a table with columns 'date', 'user_id', 'lead_id', 'listing_price', write a SQL query to select the most recent lead submission for each user.