Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Reporting with SQL

Well done!

You have completed Reporting with SQL!

Sign up for Treehouse Back to Library

Performing Math on Numeric Types

4:35 with Andrew Chalkley

Operators aren't only for comparing values or concatenating strings. They can be used to perform mathematical operations.

Mathematical Operators

  • * Multiply
  • / Divide
  • + Add
  • - Subtract
SELECT <numeric column> <mathematical operator> <numeric value> FROM <table>;

Cheat Sheets

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    We've seen [SOUND] the equality and inequality operators. 0:00
    You've seen comparison operators that test the relationships between two values. 0:00
    The operators include less than, greater than, less than or 0:07
    equal to, and greater than or equal to. 0:11
    You've also seen the concatenation operator, for adding text types together. 0:14
    Now, let's turn to operators that can perform mathematical transformations 0:20
    on numeric types. 0:25
    Firstly, there's the Addition operator that adds two numbers together. 0:27

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up