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:
All approved monthly payments between $50 and $100
All loans that have a down payment of less than $100 or $300 and more
All electronics and appliance loans
All loans, except electronics, with an installment price of over $500
any loan that do not make (Carrying Charges) more than $100