Guest User

Untitled

a guest
Feb 21st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. `data_log`(`id`, `moeda`, `moeda_simbolo`, `market_cap`, `volume`,
  2. `data_cadastro`, `percent_change_1h`, `percent_change_24h`,
  3. `percent_change_7d`, `price_usd`)
  4. VALUES (1, 'Bitcoin', 'BTC', '134001640106', '6628000000.0',
  5. '2018-02-11', '-1.07', '-10.47',
  6. '-11.75', '7948.84')
  7.  
  8. (1313, 'Kubera Coin', 'KBR', '1807270.0', '155830.0', '2018-02-11', '-2.27', '-16.9', '-7.76', '0.0157946'),
  9. (1314, 'Renos', 'RNS', '1788409.0', '2235.62', '2018-02-11', '2.0', '-3.49', '-4.48', '0.0536157'),
  10. (1315, 'FujiCoin', 'FJC', '1786980.0', '2300.57', '2018-02-11', '4.67', '-2.84', '-23.1', '0.00137009'),
  11. (1316, 'Bankcoin', 'B@', '1780694.0', '2679.29', '2018-02-11', '3.32', '348.87', '72.86', '0.173021'),
  12.  
  13. SELECT *
  14. FROM
  15. (SELECT moeda, sum(market_cap) as sum_cap, sum(volume) AS sum_volume
  16. FROM data_log
  17. WHERE data_cadastro >= '2018-02-11'
  18. AND data_cadastro <= '2018-02-18'
  19. GROUP BY moeda)
  20. AS sum_log
  21. LEFT JOIN
  22. (SELECT * FROM data_log WHERE data_cadastro = '2018-02-11') AS dl
  23. ON dl.moeda = sum_log.moeda
  24. WHERE (sum_cap - market_cap) / 3 > market_cap
  25. OR (sum_volume - volume) / 3 > volume;
Add Comment
Please, Sign In to add comment