Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
3c
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
CREATE TABLE Product( maker VARCHAR(25), model VARCHAR(25), "year" INT); CREATE TABLE Car(model VARCHAR(25), city REAL, highway REAL, style VARCHAR(25), passengers INT, trunk REAL, msrp INT); CREATE TABLE Pickup(model VARCHAR(25), city REAL, highway REAL, passengers INT, cargo REAL, towing REAL, msrp INT); CREATE TABLE EV(model VARCHAR(25), range REAL, battery REAL, passengers INT, msrp INT); --Data insert into Product (maker, model, "year") values ('Toughjoyfax', 'Down-sized', 1952); insert into Product (maker, model, "year") values ('Temp', 'framework', 1950); insert into Product (maker, model, "year") values ('Bitchip', 'dynamic', 1949); insert into Product (maker, model, "year") values ('Overhold', 'leading edge', 1907); insert into Product (maker, model, "year") values ('Tempsoft', '6th generation', 1907); insert into Product (maker, model, "year") values ('Daltfresh', 'Quality-focused', 1945); insert into Product (maker, model, "year") values ('Konklab', 'optimal', 1948); insert into Product (maker, model, "year") values ('Vagram', 'composite', 1980); insert into Product (maker, model, "year") values ('Sonair', 'ability', 1949); insert into Product (maker, model, "year") values ('Opela', 'synergy', 1969); insert into Product (maker, model, "year") values ('Namfix', 'Quality-focused', 2007); insert into Product (maker, model, "year") values ('Sonair', 'groupware', 1915); insert into Product (maker, model, "year") values ('Ventosanzap', 'strategy', 1957); insert into Product (maker, model, "year") values ('Cardify', 'Multi-lateral', 1991); insert into Product (maker, model, "year") values ('Cardify', 'utilisation', 1913); insert into Product (maker, model, "year") values ('Pannier', 'Streamlined', 1907); insert into Product (maker, model, "year") values ('Fix San', 'foreground', 1957); insert into Product (maker, model, "year") values ('Flexidy', 'Stand-alone', 1931); insert into Product (maker, model, "year") values ('Ventosanzap', 'matrix', 2016); insert into Product (maker, model, "year") values ('Ventosanzap', 'matrix2', 2016); insert into Product (maker, model, "year") values ('Ventosanzap', 'matrix3', 2016); insert into Product (maker, model, "year") values ('Subin', 'support', 1993); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('matrix', 78, 24.2, 'Green', 110, 6100, 6938); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('static', 85, 50.0, 'Teal', 8010, 4546, 4947); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('24/7', 81, 50.1, 'Green', 6320, 5277, 7500); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('even-keeled', 26, 88.8, 'Teal', 4265, 2350, 386); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('info-mediaries', 99, 18.8, 'Pink', 1310, 4487, 1872); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('superstructure', 16, 20.4, 'Fuscia', 2196, 816, 6081); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('focus group', 21, 87.9, 'Khaki', 7343, 1008, 1036); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('User-friendly', 40, 21.1, 'Puce', 805, 3856, 2329); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('transitional', 5, 25.3, 'Maroon', 7077, 8532, 2993); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('Future-proofed', 73, 14.9, 'Orange', 3302, 7198, 2193); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('Secured', 23, 18.1, 'Red', 6417, 3816, 7471); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('maximized', 22, 27.9, 'Maroon', 6862, 3249, 3545); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('Extended', 33, 45.0, 'Green', 524, 5092, 823); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('composite', 9, 18.0, 'Teal', 5426, 7513, 1942); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('circuit', 82, 94.2, 'Pink', 5286, 8202, 1893); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('approach', 76, 59.7, 'Turquoise', 7952, 5282, 8606); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('algorithm', 2, 19.0, 'Crimson', 10, 95, 8161); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('Realigned', 7, 12.9, 'Violet', 5325, 3300, 5334); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('Distributed', 27, 24.8, 'Green', 5970, 7703, 8066); insert into Car (model, city, highway, style, passengers, trunk, msrp) values ('infrastructure', 29, 26.8, 'Khaki', 4605, 8359, 4074); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('matrix3', 93, 85.8, 7367, 6774.4, 3547.6, 1927); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('benchmark', 93, 85.8, 7367, 6774.4, 3547.6, 1927); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('24/7', 5, 71.1, 1972, 4785.9, 6918.5, 7310); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Switchable', 40, 83.1, 2102, 4087.2, 792.7, 5498); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Synergistic', 81, 13.1, 3396, 6693.9, 7410.1, 3284); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Upgradable', 72, 80.5, 5665, 1265.5, 5828.4, 7234); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('asynchronous', 79, 13.7, 5606, 985.0, 3244.4, 4164); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('database', 34, 83.8, 6150, 8508.0, 1364.8, 5908); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('zero tolerance', 69, 54.6, 972, 2705.4, 353.5, 706); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('scalable', 80, 55.5, 389, 2722.8, 8895.4, 7145); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('client-driven', 28, 87.3, 7645, 7101.5, 862.7, 491); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('monitoring', 8, 20.1, 2461, 4551.4, 5124.6, 6447); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Intuitive', 58, 46.9, 2867, 8606.6, 2670.1, 218); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Switchable', 89, 11.4, 685, 172.6, 6719.8, 3496); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('data-warehouse', 34, 99.1, 8891, 6311.3, 746.4, 5946); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('standardization', 61, 90.5, 1786, 1811.2, 7536.6, 3371); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('logistical', 76, 31.5, 6665, 8349.8, 571.3, 5110); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('complexity', 56, 48.0, 8574, 3280.5, 8575.2, 3671); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Managed', 12, 88.2, 6310, 3896.9, 2233.1, 3170); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('Reduced', 37, 14.6, 8279, 1291.4, 4017.4, 2655); insert into Pickup (model, city, highway, passengers, cargo, towing, msrp) values ('strategy', 69, 54.7, 8780, 4405.9, 5938.5, 7351); insert into EV (model, range, battery, passengers, msrp) values ('modular', 98, 79.2, 1968, 3529); insert into EV (model, range, battery, passengers, msrp) values ('strategy', 30, 47.2, 6014, 4235); insert into EV (model, range, battery, passengers, msrp) values ('Reverse-engineered', 14, 36.0, 7116, 2393); insert into EV (model, range, battery, passengers, msrp) values ('framework', 11, 98.8, 5022, 4648); insert into EV (model, range, battery, passengers, msrp) values ('transitional', 82, 31.4, 943, 6175); insert into EV (model, range, battery, passengers, msrp) values ('3rd generation', 84, 99.1, 2596, 2958); insert into EV (model, range, battery, passengers, msrp) values ('ability', 20, 55.3, 4655, 2046); insert into EV (model, range, battery, passengers, msrp) values ('policy', 94, 34.2, 5878, 8961); insert into EV (model, range, battery, passengers, msrp) values ('Self-enabling', 99, 73.5, 5572, 261); insert into EV (model, range, battery, passengers, msrp) values ('6th generation', 2, 28.6, 1300, 831); insert into EV (model, range, battery, passengers, msrp) values ('executive', 16, 33.8, 5219, 7616); insert into EV (model, range, battery, passengers, msrp) values ('Realigned', 70, 40.8, 1721, 4097); insert into EV (model, range, battery, passengers, msrp) values ('leverage', 12, 88.8, 6311, 8935); insert into EV (model, range, battery, passengers, msrp) values ('Cross-platform', 40, 94.9, 8295, 7600); insert into EV (model, range, battery, passengers, msrp) values ('exuding', 96, 1.6, 6593, 2560); insert into EV (model, range, battery, passengers, msrp) values ('Ergonomic', 43, 22.7, 7456, 3854); insert into EV (model, range, battery, passengers, msrp) values ('Reactive', 73, 18.0, 8306, 7541); insert into EV (model, range, battery, passengers, msrp) values ('access', 3, 13.4, 5332, 4271); insert into EV (model, range, battery, passengers, msrp) values ('flexibility', 21, 86.3, 3261, 686); insert into EV (model, range, battery, passengers, msrp) values ('task-force', 10, 35.0, 6105, 398); (Select maker From(Select model from Car where msrp>6000 union Select model from EV where msrp>6000 union Select model from Pickup where msrp>6000)as A, Product Where Product.model = A.model ) intersect (Select maker From(Select model from Car where msrp<2500 union Select model from EV where msrp<2500 union Select model from Pickup where msrp<2500)as B, Product Where Product.model = B.model )
absolute service time: 0,41 sec
fork mode
|
history
|
discussion
maker
1
Ventosanzap