# SQL Sequence Add, Subtract, Multiply and Divide Functions

> The `seq_add()` function adds the element from sequence 1 to the corresponding element of sequence 2; the `seq_sub()` function subtracts the element of sequence 2 from the corresponding element of sequence 1; the `seq_mul()` function multiplies the two corresponding elements; and the `seq_div()` function divides the element of sequence 1 by the corresponding element of sequence 2.

> Following is an example script demonstrating the `seq_add()`, `seq_sub()`,`seq_mul()` and `seq_div()` functions:

>         INSERT INTO SimpleSequence(testNumber,dVal1,dVal2)
>         VALUES(1,'{1,2}','{3,4}');

>         SELECT dVal1,dVal2,seq_add(dVal1,dVal2) As "add" FROM SimpleSequence where testNumber=1;
>         SELECT dVal1,dVal2,seq_sub(dVal1,dVal2) As "sub" FROM SimpleSequence where testNumber=1;
>         SELECT dVal1,dVal2,seq_mul(dVal1,dVal2) As "mul" FROM SimpleSequence where testNumber=1;
>         SELECT dVal1,dVal2,seq_div(dVal1,dVal2) As "div" FROM SimpleSequence where testNumber=1;

>         dVal1{}
>         dVal2{}
>         add{}
>         --------------------------------------------------------------------
>         {1.000000, 2.000000}
>         {3.000000, 4.000000}
>         {4.000000, 6.000000}

>         dVal1{}
>         dVal2{}
>         sub{}
>         --------------------------------------------------------------------
>         {1.000000, 2.000000}
>         {3.000000, 4.000000}
>         {-2.000000, -2.00000}

>         dVal1{}
>         dVal2{}
>         mul{}
>         --------------------------------------------------------------------
>         {1.000000, 2.000000}
>         {3.000000, 4.000000}
>         {3.000000, 8.000000}

>         dVal1{}
>         dVal2{}
>         div{}
>         --------------------------------------------------------------------
>         {1.000000, 2.000000}
>         {3.000000, 4.000000}
>         {0.333333, 0.500000}

> ## Sample script

> A sample script to demonstrate this `select` statement using xSQL can be run from the `samples/xsql/scripts/financial` directory with the following command:

>         f 3