Homework Help is Here – Start Your Trial Now!
Engineering
Cybersecurity
All that is required is a Report on the findings from the query. That is, a sentence or two on th results of the query as it relates to the business. Identify any outstanding (exceptional) information which may arise from the query.

All that is required is a Report on the findings from the query. That is, a sentence or two on th results of the query as it relates to the business. Identify any outstanding (exceptional) information which may arise from the query.

icon
Related questions
Question

See \

3. From the historical currency data, what was the ATH for each currency? Show symbol. name and ATH. Q3-ATHCurrency X Symbol Currency Name bitcoin BTC BCH ETH DASH BCC NMR XMR LTC NEO ETC QTUM OMG STRAT WAVES XRP MIOTA KDA MGS XHS XEM bitcoin_cash ethereum dash Symbol BCC BCH BTC bitconnect numeraire monero litecoin neo ethereum_classic qtum omisego stratis waves ripple iota kittitian moneygramsk xyhanshasamuel nem MaxOfHigh 4. What is the average price at opening and closing for all cryptocoins beginning with the letter "B" symbol. Display the symbol, currency name and the average price at opening and closing. Currency Name bitconnect bitcoin_cash bitcoin 7617.48 1091.97 414.76 409.77 285.64 168.49 154.58 92.07 52.63 24.62 20.04 13.53 11.68 7.01 1.82 1.5 1.23 1.03 1.01 0.84 AvgOfOpen AvgOfClose 61.676810116041 62.6460966450512 439.731926605504 439.33504587156 821.640935990336 825.787506038649
Transcribed Image Text:3. From the historical currency data, what was the ATH for each currency? Show symbol. name and ATH. Q3-ATHCurrency X Symbol Currency Name bitcoin BTC BCH ETH DASH BCC NMR XMR LTC NEO ETC QTUM OMG STRAT WAVES XRP MIOTA KDA MGS XHS XEM bitcoin_cash ethereum dash Symbol BCC BCH BTC bitconnect numeraire monero litecoin neo ethereum_classic qtum omisego stratis waves ripple iota kittitian moneygramsk xyhanshasamuel nem MaxOfHigh 4. What is the average price at opening and closing for all cryptocoins beginning with the letter "B" symbol. Display the symbol, currency name and the average price at opening and closing. Currency Name bitconnect bitcoin_cash bitcoin 7617.48 1091.97 414.76 409.77 285.64 168.49 154.58 92.07 52.63 24.62 20.04 13.53 11.68 7.01 1.82 1.5 1.23 1.03 1.01 0.84 AvgOfOpen AvgOfClose 61.676810116041 62.6460966450512 439.731926605504 439.33504587156 821.640935990336 825.787506038649
Requirement Note I have attached the queries. All that is required is a Report on the findings from the query. That is, a sentence or two on th results of the query as it relates to the business. Identify any outstanding (exceptional) information which may arise from the query. * * 1. List, sorted by name, each exchange, its trading pairs greater than 200, and the volum (in bitcoins) for the last 24 hours available at the time your investigation started. Q1-Exchanges X ExchangeID Bitcoin Ethereum (New) Ripple Bitcoin Cash 7 Bittrex bitconnect Cardano Litecoin ExchangeName 40 C-Cex 26 Cryptopia 6 HitBTC 24 Livecoin Neo Stellar Lumens EOS IOTA NEM ▾ TradingPairs 2. List the name, symbol, price and market capitalization for the top 12 currencies at the time your investigation started. Q2-MarketCap X Name BTC ETH XRP BCH BCC ADA LTC NEO XLM EOS MIOTA XEM ▾ Symbol Price USD $8,767 $877 $1 $1,319 $1,324 255 232 439 269 306 $0 $160 $118 $0 $9 $2 $1 24hVolumeBTC Y 33,327 136 1,719 40,326 2,339 MarketcapUSD $145,073,531,210 $84,439,782,408 $34,509,048,527 $21,763,568,776 $11,977,468,218 $9,684,967,133 $8,685,768,894 $7,402,854,818 $7,155,013,373 $6,119,355,459 $5,335,222,827 $5,076,984,006
Transcribed Image Text:Requirement Note I have attached the queries. All that is required is a Report on the findings from the query. That is, a sentence or two on th results of the query as it relates to the business. Identify any outstanding (exceptional) information which may arise from the query. * * 1. List, sorted by name, each exchange, its trading pairs greater than 200, and the volum (in bitcoins) for the last 24 hours available at the time your investigation started. Q1-Exchanges X ExchangeID Bitcoin Ethereum (New) Ripple Bitcoin Cash 7 Bittrex bitconnect Cardano Litecoin ExchangeName 40 C-Cex 26 Cryptopia 6 HitBTC 24 Livecoin Neo Stellar Lumens EOS IOTA NEM ▾ TradingPairs 2. List the name, symbol, price and market capitalization for the top 12 currencies at the time your investigation started. Q2-MarketCap X Name BTC ETH XRP BCH BCC ADA LTC NEO XLM EOS MIOTA XEM ▾ Symbol Price USD $8,767 $877 $1 $1,319 $1,324 255 232 439 269 306 $0 $160 $118 $0 $9 $2 $1 24hVolumeBTC Y 33,327 136 1,719 40,326 2,339 MarketcapUSD $145,073,531,210 $84,439,782,408 $34,509,048,527 $21,763,568,776 $11,977,468,218 $9,684,967,133 $8,685,768,894 $7,402,854,818 $7,155,013,373 $6,119,355,459 $5,335,222,827 $5,076,984,006
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer