SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE IF NOT EXISTS coins( dt VARCHAR(16), avg_price NUMERIC, tx_cnt NUMERIC, tx_vol NUMERIC, active_addr_cnt NUMERIC, symbol VARCHAR(8), full_nm VARCHAR(128), open_price NUMERIC, high_price NUMERIC, low_price NUMERIC, close_price NUMERIC, vol NUMERIC, market NUMERIC ); INSERT INTO coins (dt, avg_price, tx_cnt, tx_vol, active_addr_cnt, symbol, full_nm, open_price, high_price, low_price, close_price, vol, market) VALUES ('2018-01-01',0.718847,2957.0,3381306310.98,6335.0,'ADA','Cardano',0.718847,0.730051,0.671941,0.728657,150186000.0,18637600000.0), ('2018-01-01',1.32,240.0,720913.363366,226.0,'AE','Aeternity',1.32,1.33,1.25,1.3,1312670.0,308110000.0), ('2018-01-01',5.24,378.0,6494275.37254,344.0,'AION','Aion',5.24,5.45,4.86,5.44,6965630.0,321171000.0), ('2018-01-01',3.83,372.0,476640.597862,421.0,'ANT','Aragon',3.83,4.3,3.47,4.27,2137650.0,123637000.0), ('2018-01-02',3.42,868.0,6362064.44835,734.0,'KNC','KingN Coin',13.23,13.8,13.1,13.5,43.0,26564.0), ('2018-01-03',3.42,868.0,6362064.44835,734.0,'KNC','KingN Coin',13.23,13.8,13.1,13.5,43.0,26564.0), ('2018-01-03',0.488586,614.0,29050802.5464,488.0,'LRC','Loopring',0.488586,0.573725,0.450985,0.56993,11634500.0,139819000.0), ('2018-01-03',21.94,4537.0,21609616.0293,2927.0,'LSK','Lisk',21.94,22.03,20.4,21.0,79068900.0,2558310000.0), ('2018-01-03',255.7,186764.0,3437564852.07,466120.0,'LTC','Litecoin',255.69,260.74,243.13,245.37,3215280000.0,13957800000.0), ('2018-01-03',1.1,233.0,4942023.9,196.0,'MAID','MaidSafeCoin',1.1,1.18,1.06,1.17,10299200.0,495603000.0), ('2018-01-03',0.104998,1654.0,8462185.85647,900.0,'MANA','Decentraland',0.104998,0.181478,0.099534,0.1559,87955800.0,238740000.0), ('2018-01-03',9.66,691.0,2838898.39607,343.0,'MTL','Metal',9.66,10.11,8.82,9.64,19728200.0,186398000.0), ('2018-01-03',5.56,1004.0,13029621.0157,868.0,'NAS','Nebulas',5.56,7.69,4.95,7.52,32260000.0,0.0), ('2018-01-15',94.47,924.0,7962876.18192,757.0,'REP','Augur',94.47,103.35,90.19,90.88,23443000.0,1039150000.0); SELECT DISTINCT ON (price) UPPER(full_nm) as full_name, dt, high_price as price FROM coins c WHERE high_price = ( SELECT MAX(sub.high_price) as price FROM coins sub WHERE sub.full_nm = c.full_nm ) ORDER BY price DESC, full_name;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear