Databases‎ > ‎

Google: Fusion Tables - Exeter Finance

Instructions:
Import the data file into a Fusion Table.
Add two calculated fields:  Installment Price and Carrying Charges 
    
Installment Price: The Installment Price can be determined by multiplying the monthly payments by the Number of Monthly Payments and adding in the Down Payment

Carrying Charges: The Carrying charges can be determined by subtracting the cash price from the installment price.

Queries:
  1. All approved monthly payments between $50 and $100 
  2. All loans that have a down payment of less than $100 or $300 and more 
  3. All electronics and appliance loans 
  4. All loans, except electronics, with an installment price of over $500 
  5. any loan that do not make (Carrying Charges) more than $100

ċ
DB Exeter Finance Import File - Data.csv
(1k)
M. A. Vandepoele,
4 Jun 2014, 18:47
Comments