-- 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