See \ 3. From the historical currency data, what was the ATH for each currency? Show symbol.name and ATH.Q3-ATHCurrency XSymbol Currency NamebitcoinBTCBCHETHDASHBCCNMRXMRLTCNEOETCQTUMOMGSTRATWAVESXRPMIOTAKDAMGSXHSXEMbitcoin_cashethereumdashSymbolBCCBCHBTCbitconnectnumerairemonerolitecoinneoethereum_classicqtumomisegostratiswavesrippleiotakittitianmoneygramskxyhanshasamuelnemMaxOfHigh4. What is the average price at opening and closing for all cryptocoins beginning with theletter "B" symbol. Display the symbol, currency name and the average price at openingand closing.Currency Namebitconnectbitcoin_cashbitcoin7617.481091.97414.76409.77285.64168.49154.5892.0752.6324.6220.0413.5311.687.011.821.51.231.031.010.84AvgOfOpenAvgOfClose61.676810116041 62.6460966450512439.731926605504439.33504587156821.640935990336 825.787506038649 RequirementNote 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 thresults 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 XExchangeIDBitcoinEthereum(New)RippleBitcoin Cash7 BittrexbitconnectCardanoLitecoinExchangeName40 C-Cex26 Cryptopia6 HitBTC24 LivecoinNeoStellar LumensEOSIOTANEM▾TradingPairs2. List the name, symbol, price and market capitalization for the top 12 currencies at thetime your investigation started.Q2-MarketCap XNameBTCETHXRPBCHBCCADALTCNEOXLMEOSMIOTAXEM▾ Symbol Price USD$8,767$877$1$1,319$1,324255232439269306$0$160$118$0$9$2$124hVolumeBTCY33,3271361,71940,3262,339MarketcapUSD$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

Question

See \ 3. From the historical currency data, what was the ATH for each currency? Show symbol.name and ATH.Q3-ATHCurrency XSymbol Currency NamebitcoinBTCBCHETHDASHBCCNMRXMRLTCNEOETCQTUMOMGSTRATWAVESXRPMIOTAKDAMGSXHSXEMbitcoin_cashethereumdashSymbolBCCBCHBTCbitconnectnumerairemonerolitecoinneoethereum_classicqtumomisegostratiswavesrippleiotakittitianmoneygramskxyhanshasamuelnemMaxOfHigh4. What is the average price at opening and closing for all cryptocoins beginning with theletter &#34;B&#34; symbol. Display the symbol, currency name and the average price at openingand closing.Currency Namebitconnectbitcoin_cashbitcoin7617.481091.97414.76409.77285.64168.49154.5892.0752.6324.6220.0413.5311.687.011.821.51.231.031.010.84AvgOfOpenAvgOfClose61.676810116041 62.6460966450512439.731926605504439.33504587156821.640935990336 825.787506038649 RequirementNote 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 thresults 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 XExchangeIDBitcoinEthereum(New)RippleBitcoin Cash7 BittrexbitconnectCardanoLitecoinExchangeName40 C-Cex26 Cryptopia6 HitBTC24 LivecoinNeoStellar LumensEOSIOTANEM▾TradingPairs2. List the name, symbol, price and market capitalization for the top 12 currencies at thetime your investigation started.Q2-MarketCap XNameBTCETHXRPBCHBCCADALTCNEOXLMEOSMIOTAXEM▾ Symbol Price USD$8,767$877$1$1,319$1,324255232439269306$0$160$118$0$9$2$124hVolumeBTCY33,3271361,71940,3262,339MarketcapUSD$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

Accepted Answer

Queries are used to fetch crypto data. This plays a crucial role in the cryptocurrency ecosystem,…

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.