CommencerCommencer gratuitement

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 /.

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Instructions

  • Add 0.50 to the total amount listed on the invoice.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Add 50 cents to the total amount
___ ___ ___ ___
___ ___
Modifier et exécuter le code