SQL queries

SELECT  e.FirstName + ' ' + e.LastName AS [FULL Name], e.Salary FROM  Employees AS e

SELECT  FirstName + '.' + LastName +'@telerik.com' AS [Email Address] FROM  Employees

SELECT  DISTINCT salary FROM Employees

SELECT * FROM Employees WHERE JobTitle = 'Sales Representative'

SELECT FirstName, LastName FROM Employees WHERE FirstName LIKE 'sa%'

SELECT FirstName, LastName FROM Employees WHERE LastName LIKE '%ei%'

SELECT FirstName, LastName FROM Employees WHERE Salary BETWEEN 20000 AND 30000

SELECT FirstName, LastName FROM Employees WHERE Salary IN (25000, 14000, 12500 ,23600)

SELECT FirstName, LastName FROM Employees WHERE ManagerID IS NULL --=(equal) don't work for null

SELECT FirstName, LastName, Salary FROM Employees WHERE Salary > 50000 ORDER BY Salary DESC

SELECT TOP 5 FirstName, LastName, Salary FROM Employees ORDER BY Salary DESC

SELECT e.FirstName +' '+ e.LastName AS [FULL Name], a.AddressText FROM Employees e JOIN Addresses a ON e.AddressID = a.AddressID

--equi join
SELECT e.FirstName +' '+ e.LastName AS [FULL Name], a.AddressText FROM Employees e ,Addresses a WHERE e.AddressID = a.AddressID

--self join
SELECT e.FirstName AS Employee, m.FirstName AS Manager FROM Employees e LEFT OUTER JOIN Employees m ON e.ManagerID = m.EmployeeID

--3 tables join
SELECT e.FirstName AS Employee, a.AddressText AS Address, m.FirstName AS Manager FROM Employees e LEFT OUTER JOIN Employees m ON e.ManagerID = m.EmployeeID JOIN Addresses a ON
e.AddressID = a.AddressID

SELECT d.Name FROM Departments d
UNION
SELECT t.Name FROM Towns t

SELECT e.FirstName FROM Employees e JOIN Departments d ON e.DepartmentID = d.DepartmentID WHERE d.Name IN ('Sales', 'Finance') AND (e.HireDate  BETWEEN '1995-01-01' AND '2005-01-01')