Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
3c
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 )
run
|
edit
|
history
|
help
0
finale47394372
E2
IF IN POSTGRESQL
select distinct
Select the latest id from last week from each different contact without repeating barcodes .....
SQL social network practice by Han Wang 20200720
Full text search
1225. Report Contiguous Dates
Ecommerce Website Analysis by SQL
loggin_trigger-audit