metricsdao | Flipside Analyst

    metricsdao

    Joined Jul 12, 2022
    //
    5Upvotes
    Query
    Copy of [07] Multiple WHERE Clauses: Logic Operators
    ethereumethereum
    evm
    [01] Rows vs. Unique tx hashes for October 2022 (Ethereum ez_nft_mints table)
    ethereumethereum
    nft
    evm
    Untitled Query
    ethereumethereum
    nft
    evm
    [09] WHERE Value Contains LIKE
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [17] MDAO 101: GROUP BY + HAVING
    ethereumethereum
    nft
    evm
    Copy of [13] COUNT Distinct Transactions
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [18] MDAO 101: CASE Statement
    ethereumethereum
    nft
    evm
    Untitled Query
    ethereumethereum
    evm
    [10] MDAO 101: SQL WHERE BETWEEN
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    Segment 3 Live
    ethereumethereum
    nft
    evm
    Copy of [09] WHERE Value Contains LIKE
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    101: C4W3 Quiz
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [14] MDAO 101: SQL AVG MIN MAX MEDIAN
    ethereumethereum
    nft
    evm
    2023-03-10 10:02 AM
    ethereumethereum
    nft
    evm
    [20] MDAO 101: CTEs
    ethereumethereum
    nft
    evm
    [10] Records WHERE Value Contains LIKE
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    What are all the ways quiz 3 q10 can be written?
    ethereumethereum
    nft
    evm
    Copy of [12] COUNT Records
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [04] HAVING: The filter for GROUP BY slices
    ethereumethereum
    nft
    evm
    101 C4W2Q2
    ethereumethereum
    nft
    evm
    [12] COUNT Records
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [19] Min, Max, Median, Avg
    ethereumethereum
    nft
    evm
    [16] NFT Sales OpenSea: Platform Fees
    ethereumethereum
    nft
    evm
    [06] CASE statement
    ethereumethereum
    nft
    evm
    [05] GROUP BY a datetime variable (October 1, 2022)
    ethereumethereum
    nft
    evm
    [01] MDAO 101: SQL SELECT Statement
    ethereumethereum
    evm
    [08] Multiple WHERE Clauses: IN
    ethereumethereum
    evm
    [21] MDAO 101: CTEs & Joins
    ethereumethereum
    nft
    evm
    [13] MDAO 101: SQL SUM
    ethereumethereum
    nft
    evm
    [17] NFT Sales OpenSea: Platform Fee Currencies
    ethereumethereum
    nft
    evm
    [09] MDAO 101: SQL WHERE IN
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [12] MDAO 101: SQL COUNT
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [03] Introducing GROUP BY
    ethereumethereum
    nft
    evm
    [01] Comparing block_timestamp to date range
    ethereumethereum
    nft
    evm
    [18] MDAO 101: CASE Statement
    ethereumethereum
    nft
    evm
    [19] MDAO 101: DATE_TRUNC
    ethereumethereum
    nft
    evm
    [02] Comparing date to date range
    ethereumethereum
    nft
    evm
    [04] MDAO 101: SQL ORDER BY
    ethereumethereum
    evm
    [13] COUNT Distinct Transactions
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    [18] NFT Sales OpenSea: Platform Fees in ETH
    ethereumethereum
    nft
    evm