Question 212

Highest spender's issuers

Premium Access

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) 
  ****                  | ***
  *****                 | ***
  *****_******          | *****

Sample results


        
    

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Copied
Expected results

Submit a query to compare against expected output.