Crud

SELECT [Name] FROM [Departments] --03

---------------------------

SELECT [FirstName],LastName,Salary FROM Employees --04

-------------


SELECT [FirstName],MiddleName,LastName FROM Employees --05

-----

select CONCAT([FirstName],'.',[LastName],'@softuni.bg') AS [Full Email Address] from Employees --06

----

select distinct [Salary] from Employees --07

----

select * from Employees where [JobTitle] = 'Sales Representative' --8

----

select [FirstName],LastName,JobTitle from Employees where Salary between 20000 and 30000 --9

----

select CONCAT(FirstName,' ',MiddleName,' ',LastName) AS [Full Name]FROM Employees where salary = 25000 OR salary = 14000 or Salary = 12500 or Salary = 23600 -- 10

----

select FirstName,LastName from Employees where ManagerID IS null --11

--

select FirstName,LastName,Salary from Employees where salary > 50000 ORDER BY [Salary] DESC --12

--

select top 5 FirstName,LastName from Employees order by Salary desc --13

--

select FirstName,LastName from Employees where DepartmentID != 4 --14

--

select * from Employees order by Salary desc, FirstName asc,LastName desc, MiddleName asc --15

--

create view [V_EmployeesSalaries] AS select FirstName,LastName,Salary from Employees --16

--

create view [V_EmployeeNameJobTitle] as select CONCAT(FirstName,' ',MiddleName,' ',LastName) AS [Full Name],JobTitle from Employees --17

--

select distinct [JobTitle] from Employees --18

--

select top 10 * from [Projects] where StartDate is not null order by StartDate asc, [Name] asc --19

--

select top 7 [FirstName],LastName,HireDate from Employees where [EmployeeID] >= 193 order by HireDate desc --20

--

update [Employees] SET Salary = Salary + Salary * 0.12 WHERE DepartmentID = 1 OR DepartmentID = 2 OR DepartmentID =  4 OR DepartmentID =  11 select Salary from Employees --21

--

select PeakName from [Peaks] order by [PeakName] asc --22

---

select top 30 CountryName,[Population] from Countries where ContinentCode = 'EU' order by Population desc,CountryName asc --23

--

select CountryName,CountryCode,
CASE
     when CurrencyCode = 'EUR' then 'Euro'
     ELSE 'Not Euro'
END AS [Currency]
from Countries order by CountryName asc  --- 24

----

select [Name] from Characters order by [Name] asc  ---25