Untitled

use [Orders]

delete from Products
delete from Customers
delete from Orders
delete from OrderItems

insert into Products(ProductCode, Name, Price, StockQuantity)
values
('P01', 'Paper A4', '10', '5000'),
('P02', 'Keyboard', '15', '480'),
('P03',	'Mouse', '12', '800'),
('P04',	'17’’ LCD Monitor',	'119', '800'),
('P05', '21’’ LCD Monitor','219', '100'),
('P06', 'USB 8G', '45', '150'),
('P07', 'USB 16G', '60', '500')

insert into Customers
values
('C01', N'Nguyễn Thị Bé', 'Tân Bình', '08457895', 'bnt@yahoo.com'),
('C02', N'Lê Hoàng Nam', 'Bình Chánh', '09878987','namlehoang@abc.com.vn'),
('C03', N'Trần Thị Chiêu', 'Tân Bình', '08457895', ''),
('C04', N'Mai Thị Quế Anh', 'Bình Chánh', '', ''),
('C05', N'Lê Văn Sáng', 'Quận 10', '', 'sanglv@hcm.vnn.vn'),
('C06', N'Trần Hoàng Khải', 'Tân Bình', '08457897', '')

insert into Orders(OrderID, Date, CustomerID)
values
('Or001', '2000-05-12', 'C01'),
('Or002', '2000-05-25', 'C02'),
('Or003', '2000-05-25', 'C01'),
('Or004', '2000-05-25', 'C04'),
('Or005', '2000-05-26', 'C04'),
('Or006', '2000-06-02', 'C03'),
('Or007', '2000-06-22', 'C04'),
('Or008', '2000-06-25', 'C03'),
('Or009', '2000-08-15', 'C04'),
('Or010', '2000-09-30', 'C01'),
('Or011', '2000-12-27', 'C06'),
('Or012', '2000-12-27', 'C01')

insert into OrderItems(OrderID, ProductCode, Quantity, SellPrice)
values
('Or001', 'P01', '5', '12'),
('Or001', 'P05', '10', '300'),
('Or002', 'P03', '4', '13'),
('Or003', 'P02', '20', '16'),
('Or004', 'P03', '3', '13'),
('Or004', 'P04', '10', '120'),
('Or005', 'P05', '10', '309'),
('Or005', 'P06', '15', '46.6'),
('Or005', 'P07', '20', '70'),
('Or006', 'P04', '10', '120'),
('Or007', 'P04', '20', '125'),
('Or008', 'P01', '2', '11.5'),
('Or008', 'P02', '20', '16'),
('Or009', 'P02', '25', '17'),
('Or010', 'P01', '25', '11.5'),
('Or011', 'P01', '20', '12'),
('Or011', 'P02', '20', '17'),
('Or012', 'P01', '20', '12'),
('Or012', 'P02', '10', '16.5'),
('Or012', 'P03', '1', '13.5')

select * from Products
select * from Customers
select * from Orders
select * from OrderItems