SQL Query Examples: Math Functions & Join Types Explained with Code

Explore essential SQL queries using math functions and different types of joins!
This video demonstrates query syntax for basic arithmetic operations and joins between tables.

---

✅ 1) Math Function Queries:

SELECT Name, Salary, Salary + 5000 AS Increased_Salary FROM Employees;

SELECT Name, Salary, Salary - 2000 AS After_Tax_Salary FROM Employees;

SELECT Name, Salary, Salary * 1.10 AS New_Salary FROM Employees;

SELECT Name, Salary, Salary / 12 AS Monthly_Salary FROM Employees;

SELECT Name, Salary, Salary % 2 AS Remainder FROM Employees;

SELECT Name, Salary, (Salary * 1.10 * 12) - 3000 AS Final_Annual_Income FROM Employees;

---

🔗 2) Join Queries:

1. INNER JOIN

SELECT E.Name, D.Dept_Name
FROM Employees E
INNER JOIN Departments D ON E.Dept_ID = D.Dept_ID;

2. LEFT OUTER JOIN

SELECT E.Name, D.Dept_Name
FROM Employees E
LEFT OUTER JOIN Departments D ON E.Dept_ID = D.Dept_ID;

3. RIGHT OUTER JOIN

SELECT E.Name, D.Dept_Name
FROM Employees E
RIGHT OUTER JOIN Departments D ON E.Dept_ID = D.Dept_ID;

4. FULL OUTER JOIN (If supported)

SELECT E.Name, D.Dept_Name
FROM Employees E
FULL OUTER JOIN Departments D ON E.Dept_ID = D.Dept_ID;

Or (for compatibility):

SELECT E.Name, D.Dept_Name
FROM Employees E
LEFT JOIN Departments D ON E.Dept_ID = D.Dept_ID
UNION
SELECT E.Name, D.Dept_Name
FROM Employees E
RIGHT JOIN Departments D ON E.Dept_ID = D.Dept_ID;

---

👍 Great for students, developers, and anyone practicing SQL syntax!

#SQL #SQLQueries #SQLJoins #MathFunctions #InnerJoin #LeftJoin #RightJoin #FullOuterJoin #SQLBasics #LearnSQL #SQLExamples