-- 1.
Select * from Employees

-- 2.
Select * from Categories

-- 3.
Select FirstName, LastName from Employees

-- 4.
Select CategoryName, Description from Categories

-- 5.
Select * from Region

-- 6.
Insert into Region (RegionID, RegionDescription)
values (5, 'Canada')

-- 7.
Select * from Region

-- 8.
Insert into Region (RegionID, RegionDescription)
values (6, 'Mexico')

-- 9.
Update Region set RegionDescription='Canada and Alaska' where RegionID = 5

-- 10.
Update Region set RegionDescription='New Mexico' where RegionID = 6

-- 11.
Delete from Region where RegionID = 5

-- 12.
Delete from Region where RegionID = 6

-- 13.
Select Address, BirthDate, City, Country, Extension from Employees

-- 14.
Select FirstName, LastName from Employees ORDER BY LastName ASC

-- 15.
Select * from Orders
where Freight <= 30 and ShipCountry = 'USA'
ORDER BY Freight ASC