Arithmetic expressions
You just heard that there is a 50 cent transaction fee for people buying music on eSymphony. Let's create a new column that holds the final amount a customer has paid. The information you need is in the Total column of the Invoice table.
Remember that in the SELECT statement you can use the following arithmetic operators: +, -, *, and /.
Diese Übung ist Teil des Kurses
Introduction to Oracle SQL
Anleitung zur Übung
- Add
0.50to the total amount listed on the invoice.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Add 50 cents to the total amount
___ ___ ___ ___
___ ___