Retrieving Data Using SELECT 1: Using Arithmetic Operators a. Every customer has been told they can pay off their current balance over a 12 month period. Display the customers first name, last name, current balance and monthly payment. b. Obl is considering giving a gift card to all its customers of 5.00 that can be used to reduce their current balance. Write a query that will show the customers first name, last name, customer number, current balance and the value of their balance minus the gift value. c. What would be the problem with implementing this scheme?

Part 2 : Using Column Aliases You previously wrote a query that display the customers first name, last name, current balance and monthly payment. Rewrite the query to use First Name, Last Name, Balance and Monthly Repayments as the column aliases. The aliases are to be shown exactly as described (case sensitive).

Part 3:

Using Literal Character Strings a. Write a query that will display the team information in the following format: The Rockets team has 25 players and receives a discount of 10 percent. Use Team Information as the column alias. b. Why does the last team not show a discount