Unlock this Visa interview question.
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
- 230+ interview questions
- Official solutions
- SQL, Python, and R tracks
***** ** 2023-05-01
***** * ***** ** ****** ***** ******'* *********** ******* ** ***** ******** ******** ** *** ***** 4 ****** ** **** ****.
***********_******* = ***********_**** * *****_******
Table 1:
visa_interchange_rate
*********** **** ** * *** **** * ******** **** *** **** ***** ****** *** ***** **** ***********, ** *** ******* ****.
*** **** ** ******* *** ** *** ******* **** ** ******** ********, *** ***** ****** *** * ********* *** ** *****. *.*., **** ** ******* *** **** * *********** **** *** ********* ** 0.3%.
***_**** | ***_****
------------------+--------------------------
******_** | ******
********_******** | *******(100)
***********_**** | *****
Table 2:
visa_sales
******* **** ****** ***** ******* ************. ****** ** * ******* ****
*** *******: * ******** **** *** *** * **** **** ****** ** **** ** ******* (******)
***_**** | ***_****
------------------------+--------------------------
********_** | ******
******_** | ******
********_******** | *******(100)
**** | ***
***** | ***
*****_****** | *****