SELECT * FROM Departments

SELECT Name FROM Departments

SELECT Salary FROM Employees

SELECT REPLACE(FirstName + ' ' + ISNULL(MiddleName, '') + ' ' + LastName, '  ', ' ') AS [FULL Name] FROM Employees

SELECT FirstName + '.' + LastName + '@softuni.bg' AS [Email] FROM Employees

SELECT DISTINCT Salary FROM Employees

SELECT * FROM Employees
WHERE JobTitle = 'Sales Representative'

SELECT REPLACE(FirstName + ' ' + ISNULL(MiddleName, '') + ' ' + LastName, '  ', ' ') AS [FULL Name] FROM Employees
WHERE FirstName LIKE 'sa%'

SELECT REPLACE(FirstName + ' ' + ISNULL(MiddleName, '') + ' ' + LastName, '  ', ' ') AS [FULL Name] FROM Employees
WHERE LastName LIKE '%ei%'

SELECT Salary FROM Employees
WHERE Salary BETWEEN 20000 AND 30000
ORDER BY Salary ASC

SELECT REPLACE(FirstName + ' ' + ISNULL(MiddleName, '') + ' ' + LastName, '  ', ' ') AS [FULL Name], Salary FROM Employees
WHERE Salary IN(25000, 14000, 12500, 23600)

SELECT * FROM Employees
WHERE ManagerID IS NULL

SELECT * FROM Employees
WHERE Salary > 50000
ORDER BY Salary DESC

SELECT TOP 5 * FROM Employees
WHERE Salary > 50000
ORDER BY Salary DESC

SELECT FirstName + ' ' + LastName AS [FULL Name], ads.AddressText AS [Address] FROM Employees emp
INNER JOIN Addresses ads ON emp.AddressID = ads.AddressID

SELECT FirstName + ' ' + LastName AS [FULL Name], ads.AddressText AS [Address] FROM Employees emp, Addresses ads
WHERE emp.AddressID = ads.AddressID

SELECT emp.FirstName + ' ' + emp.LastName AS [FULL Name], em.FirstName + ' ' + em.LastName AS [Manager] FROM Employees emp
INNER JOIN Employees em ON emp.ManagerID = em.EmployeeID

SELECT emp.FirstName + ' ' + emp.LastName AS [FULL Name], ads.AddressText AS [Address], em.FirstName + ' ' + em.LastName AS [Manager] FROM Employees emp
INNER JOIN Employees em ON emp.ManagerID = em.EmployeeID
INNER JOIN Addresses ads ON ads.AddressID = emp.AddressID

SELECT Name FROM Departments
UNION
SELECT Name FROM Towns

SELECT emp.FirstName + ' ' + emp.LastName AS [FULL Name], man.FirstName + ' ' + man.LastName AS [Manager Name] FROM Employees emp
LEFT OUTER JOIN Employees man ON emp.ManagerID = man.EmployeeID

SELECT emp.FirstName + ' ' + emp.LastName AS [FULL Name], dep.Name AS [Department Name], YEAR(emp.HireDate) AS [YEAR OF Hire] FROM Employees emp
INNER JOIN Departments dep ON dep.DepartmentID = emp.DepartmentID
WHERE dep.Name IN('Sales', 'Finance')
AND
YEAR(emp.HireDate) BETWEEN 1995 AND 2005