EbasiMaikata

USE NorthWindS
GO
CREATE TABLE FoodTypes
(FoodTypeID smallint PRIMARY KEY,
FoodTypeName nvarchar(40) NOT NULL)

CREATE TABLE Foods
(
FoodID int PRIMARY KEY,
FoodTypeID smallint NOT NULL FOREIGN KEY REFERENCES FoodTypes(FoodTypeID),
FoodName nvarchar(40) NOT NULL
)

ALTER TABLE Foods
ADD Calories int

ALTER TABLE Foods
ADD CHECK(Calories Between 0 and 1000)

INSERT INTO FoodTypes
VALUES (1,N'Foods from plant sources')

INSERT INTO FoodTypes
VALUES (2,N'Foods from animal sources')

INSERT INTO Foods
VALUES (1,1,N'Broccoli',301)

INSERT INTO Foods
VALUES (2,2,N'Butter',726)

INSERT INTO Foods
VALUES (3,2,N'Cheese',396)

UPDATE Foods
SET Calories=31
WHERE FoodID=1

DELETE FROM Foods
WHERE Calories >'100'

DROP TABLE dbo.Foods;
DROP TABLE dbo.FoodTypes;

SELECT CompanyName,Country, City, Address
FROM Customers
ORDER BY CompanyName ASC


SELECT ProductID, ProductName
FROM Products
WHERE CategoryID=1
GROUP BY ProductID, ProductName

SELECT Quantity, UnitPrice
FROM [Order Details]