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 ****** ** 2023.
- ********* *******: * ******** *** ***** *** **** ** **** ******** ********.
- ** ***** *** ****, ****** ***.
- * ******** *** **** ******** *******, ****** *** ** ****.
Table 1:
visa_interchange_rate
*********** **** ** * *** **** * ******** **** *** **** ***** ****** *** ***** **** ***********, ** *** ******* ****.
*** **** ** ******* *** ** *** ******* **** ** ******** ********, *** ***** ****** *** * ********* *** ** *****. *.*., **** ** ******* *** **** * *********** **** *** ********* ** 0.3%.
***_**** | ***_****
------------------+--------------------------
******_** | ******
********_******** | *******(100)
***********_**** | *****
Table 2:
visa_sales
******* **** ****** ***** ******* ************. ****** ** * ******* ****
*** *******: * ******** **** *** *** * **** **** ****** ** **** ** ******* (******)
***_**** | ***_****
------------------------+--------------------------
********_** | ******
******_** | ******
********_******** | *******(100)
**** | ***
***** | ***
*****_****** | *****