discover在amazon的5% cb是按照charged还是下单时间?# Money - 海外理财
e*0
1 楼
take home assignment里的一道。由于我assigment做挂了,所以没机会知道反馈了。
想知道有什么好的写法。
table:
row_id - A unique id for the row
customer_id — A unique id for the loan borrower
loan_amount — The amount of the loan requested by the borrower
addr_state — Borrower's state of residence
问题:
Now let's rank the states by their top decile of loans to see where
customers borrow the most. Find the states where the cutoff for the top 10%
of loans (by loan amount requested) is the highest. If two states have the
same cut-off for the top decile, then please break ties by preferring the
state with the highest number of loans requested. Provide the list of the
top 10 states ranked in this manner as well as the total number of loans
requested in each state and the loan amount cut-off for the top decile of
loans.
多谢大家!
想知道有什么好的写法。
table:
row_id - A unique id for the row
customer_id — A unique id for the loan borrower
loan_amount — The amount of the loan requested by the borrower
addr_state — Borrower's state of residence
问题:
Now let's rank the states by their top decile of loans to see where
customers borrow the most. Find the states where the cutoff for the top 10%
of loans (by loan amount requested) is the highest. If two states have the
same cut-off for the top decile, then please break ties by preferring the
state with the highest number of loans requested. Provide the list of the
top 10 states ranked in this manner as well as the total number of loans
requested in each state and the loan amount cut-off for the top decile of
loans.
多谢大家!