[SQL] 20. Hacker_Rank Advanced Certificates - A number of algorithms are used to mine cryptocurrencies. As part of a comparison, create a query to return a list of algorithms and their volumes for each quarter of the year 2020. https://www.hackerrank.com/certificates/iframe/8e57e6090694 HackerRank Join over 16 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. www.hackerrank.com SELECT sender, Min(dt) AS sequence_start, Max(dt) AS sequence_end, Count(*) AS transactions_count, Sum(amount) AS transactions_sum FROM transactions WHERE sender = recipient .. 2023. 1. 25. 이전 1 다음 반응형
