doordash fraud takehome

You are given a month's worth of  delivery data for DoorDash. This isn't the complete set, but it's comprehensive enough where you should be able to draw conclusions on fraudulent transactions. Feel free to make any assumptions you need. Your job is to give me a specific set of recommendations on how to reduce our fraud losses based on this data. Please send me your recommendations and any supporting analyses and assumptions.

Below is a glossary of definitions for the variables included in the data set:Field        Definition
DELIVERY_ID        ID of Order
CREATED_AT        Timestamp for order creation
CONSUMER_ID        ID of consumer account
GOV        Gross Order Value, in cents. This includes the subtotal of all items, all fees, taxes, and tip
CX_AGE_ON_DELIVERY_BASED_ON_FIRST_ORDER        Age of consumer in days when the consumer when delivery was created, calculated from the day of the first order created by the consumer
PLATFORM        Platform of device used upon checkout
RECEIVED_CHARGEBACK        Whether or not this delivery has a chargeback associated with it
IS_FRAUDULENT_CHARGEBACK        Whether or not the chargeback received was related to fraud reasons. This is true when the dispute reason is in ('fraudulent', 'unrecognized', 'general'), based on the information submitted to the card issuer by the card owner
CHARGEBACK_COST        Chargeback cost in cents is the total potential cost of chargebacks to us. Each chargeback cost is compromised of the original chargeback amount (usually entire transaction amount) + a flat chargeback processing fee that is paid to our payment processor. If we 'win' the chargeback, this value goes to 0.
CX_DEVICE_ORDER_NUM        The order number placed by this device + consumer
CX_A

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

4        3        3        3        4        2                        47.99543643        0        0        0        4        0.75        3        1        0.333333
137298413        2019-01-21T01:11:55.612066Z        50791623        13926        132        iOS        0        0                6        2        5        6        2                                0        0        0        6        0        5        0        0
131111835        2019-01-07T17:11:32.993062Z        70624886        12110        0        iOS        1        1        12860        2        2        2        2        1                        75.88508772        4        4        4        2        0.5        1        0        0
140922768        2019-01-28T17:01:43.02419Z        42558322        3557        162        iOS        0        0                26        10        12        26        19        0        2        14.50765841        0        0        0        75        0        25        0        0

攒着看，感谢楼主分享！

请问楼主这是take home quiz还是sql题目呢