How to Use Arithmetic Operators in SQL? Backend Development with Meta

? Complete Playlist of Backend Development with Meta https://www.youtube.com/playlist?list=PLfQLfkzgFi7aHmIYplbimfV_WViUzC4vU

So far, you have learned how to use SQL arithmetic operators to perform basic functions. In this video, you'll take one step further by learning how to use these arithmetic operators in practice when working with a database. Let's explore the use of arithmetic operators using the example of a corporate table of employee data. It's populated with the following information about each employee: ID, name, and salary. I'm going to demonstrate how to use each of the arithmetic operators in SQL to perform various functions with this practical data and retrieve the desired results. In this first example, let's say that an employer wants to give each employee on their team a $500 bonus. But first, they'd like to see what each employee's salary looks like after adding the $500. I can type SELECT salary plus 500 FROM employee to add the $500 bonus to each employee's salary. The SELECT command works by retrieving the salary of each employee from the employee table and then adding $500 to each value. Let's execute the query by clicking the go button. The result is that each employee's salary has increased by 500. You can create other statements that use the SELECT command in a similar way. For example, let's say the employer wants to deduct $500 from the salary of each employee. To do this, I typed the SQL query statement. SELECT salary minus 500 from employee. Again, I'm using the select command to retrieve the salary value of each employee record stored in the employee table. This time, I used a subtraction sign minus subtract $500 from the salary of each employee. Now I click the Go button and the database returns a table that shows the output result of salaries after the deductions. In the next example, let's imagine a scenario where the employer would like to increase the employee's salaries by doubling their current annual salary. To do this, I use the SELECT command to perform the same function as discussed previously. I then use the multiplication sign, an asterisk symbol to multiply the salary value of each employee by two. The SQL statement now reads SELECT salary asterisks two from employee. I can now click the Go button to generate an output of the results of salaries from multiplying the values by two.

Subscribe to our channel for more computer science related tutorials| https://www.youtube.com/@learnwithgeeks