text: USE SoftUni
  
  // 2
  
  SELECT * FROM Departments
  
  // 3
  
  SELECT [Name]
  FROM Departments
  
  //4
  
  SELECT FirstName, LastName, Salary
  FROM Employees
  
  //5 
  
  SELECT FirstName, MiddleName, LastName
  FROM Employees
  
  //6
  
  SELECT FirstName + '.' + LastName + '@softuni.bg' AS'Full Email Addresses'
  FROM Employees
  
  //7
  
  SELECT DISTINCT Salary
  FROM Employees
  
  //8
  
  SELECT * 
  FROM Employees
  WHERE JobTitle =  'Sales Representative'
  
  //9
  
  SELECT FirstName, LastName, JobTitle
  FROM Employees
  WHERE Salary BETWEEN 20000 AND 30000
  
  //10
  SELECT FirstName + ' ' + MiddleName + ' ' + LastName AS [Full Name]
  FROM Employees
  WHERE Salary IN (25000, 14000, 12500,23600)
  
  //11
  SELECT FirstName, LastName
  FROM Employees
  WHERE ManagerID IS NULL
  
  //12
  SELECT FirstName, LastName, Salary
  FROM Employees
  WHERE Salary>50000
  ORDER BY Salary DESC
  
  //13
  SELECT TOP (5) FirstName, LastName
  FROM Employees 
  ORDER BY Salary DESC
  
  
  //14
  SELECT FirstName, LastName
  FROM Employees
  WHERE NOT(DepartmentId = 4)
  
  //15
  SELECT *
  FROM Employees
  ORDER BY Salary DESC, FirstName, LastName DESC, MiddleName
  
  //16
  CREATE VIEW v_EmployeesSalaries AS
  SELECT FirstName, LastName, Salary
  FROM Employees
  
  //17
  CREATE VIEW V_EmployeeNameJobTitle AS
  SELECT FirstName + ' ' + ISNULL(MiddleName, '')+ ' '+ LastName AS 'Full Name', JobTitle AS 'Job Title'
  FROM Employees
  
  //18
  SELECT DISTINCT JobTitle
  FROM Employees
  
  //19
  SELECT TOP (10) *
  FROM Projects
  ORDER BY StartDate, [Name]
  
  //20
  SELECT TOP(7) FirstName, LastName, HireDate
  FROM Employees
  ORDER BY HireDate DESC
  
  //21
  UPDATE Employees
  SET Salary = Salary * 1.12
  WHERE DepartmentId IN (1,2,4,11)
  
  //22
  USE Geography
  SELECT PeakName
  FROM Peaks
  
  //23
  SELECT CountryName, Population
  FROM Countries
  ORDER BY [Population] DESC
  
  //24
  SELECT CountryName, CountryCode, 
  CASE CurrencyCode WHEN 'EUR' THEN 'Euro' ELSE 'Not Euro' END AS 'Currency'
  FROM Countries
  ORDER BY CountryName
  
  //25
  USE Diablo;
  
  SELECT [Name]
  FROM Characters
  ORDER BY [Name];