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
On this page of the site you can watch the video online SQL Query Examples: Math Functions & Join Types Explained with Code with a duration of hours minute second in good quality, which was uploaded by the user Sakshi 02 June 2025, share the link with friends and acquaintances, this video has already been watched 16 times on youtube and it was liked by like viewers. Enjoy your viewing!
