SQLize Online / PHPize Online  /  SQLtest Online

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') ;