CREATE TABLE Client_info
([ClientID] varchar(6), [City] varchar(50))
;
INSERT INTO Client_info
([ClientID] , [City])
VALUES
( '822353', 'Kazan'),
( '694330', 'Kazan'),
( '412830', 'Kazan'),
( '722464', 'Kazan'),
( '303510', 'Kazan'),
( '327730', 'Sankt-Peterburg'),
( '974994', 'Sankt-Peterburg'),
( '501716', 'Sankt-Peterburg'),
( '400730', 'Sankt-Peterburg'),
( '760556', 'Sankt-Peterburg'),
( '866797', 'Sankt-Peterburg'),
( '934230', 'Sankt-Peterburg'),
( '494558', 'Sankt-Peterburg'),
( '517881', 'Sankt-Peterburg'),
( '863773', 'Moscow'),
( '802312', 'Moscow'),
( '746379', 'Moscow'),
( '271567', 'Moscow'),
( '955631', 'Moscow'),
( '466287', 'Moscow'),
( '539442', 'Moscow'),
( '372476', 'Moscow'),
( '433381', 'Moscow'),
( '602353', 'Moscow'),
( '815976', 'Moscow'),
( '713649', 'Moscow'),
( '932794', 'Moscow'),
( '877365', 'Moscow')
;
CREATE TABLE Order_info
([OrderID] varchar(9), [ClientID] varchar(6), [Item] varchar(30))
;
INSERT INTO Order_info
([OrderID] , [ClientID], [Item])
VALUES
( '850840535', '822353', 'Dress'),
( '850840535', '822353', 'Socks'),
( '850840535', '822353', 'Curtains'),
( '708501413', '694330', 'Jacket'),
( '708501413', '694330', 'Pants'),
( '348586676', '412830', 'Sofa'),
( '288654482', '327730', 'Dress'),
( '288654482', '327730', 'Pants'),
( '288654482', '327730', 'Jacket'),
( '288654482', '327730', 'Socks'),
( '750884288', '974994', 'Dress'),
( '750884288', '974994', 'Pants'),
( '750884288', '974994', 'Sofa'),
( '750884288', '974994', 'Curtains'),
( '463930571', '501716', 'Curtains'),
( '463930571', '501716', 'Sofa'),
( '652237630', '400730', 'Jacket'),
( '652237630', '400730', 'Socks'),
( '652237630', '400730', 'Curtains'),
( '628409403', '955631', 'Bed'),
( '628409403', '955631', 'Curtains'),
( '509824566', '466287', 'Table'),
( '509824566', '466287', 'Bed'),
( '867337795', '539442', 'Pants'),
( '867337795', '539442', 'Jacket'),
( '867337795', '539442', 'Socks'),
( '527756777', '372476', 'Dress'),
( '527756777', '372476', 'Pants'),
( '527756777', '372476', 'Jacket'),
( '841157684', '433381', 'Curtains'),
( '841157684', '433381', 'Sofa'),
( '841157684', '433381', 'Pants'),
( '344921087', '602353', 'Dress'),
( '344921087', '602353', 'Jacket'),
( '344921087', '602353', 'Socks')
;
CREATE TABLE Items_Fashion
([Item] varchar(30), [Cost] numeric(8,2))
;
INSERT INTO Items_Fashion
([Item] , [Cost])
VALUES
( 'Dress', '4999'),
( 'Pants', '3500'),
( 'Jacket', '9000'),
( 'Socks', '200')
;
CREATE TABLE Items_Furniture
([Item] varchar(30), [Cost] numeric(8,2))
;
INSERT INTO Items_Furniture
([Item] , [Cost])
VALUES
( 'Sofa', '42999'),
( 'Curtains', '8000'),
( 'Table', '15500'),
( 'Bed', '25300')
;
Telegram: DB developers channel