Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular

SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code. You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.

Copy Format Clear
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') ;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear