Hi All,
I want to write a graphql query with join and condition
ex: SELECT contracts.address, COUNT(1) AS tx_count
FROM bigquery-public-data.crypto_ethereum.contracts
AS contracts
JOIN bigquery-public-data.crypto_ethereum.transactions
AS transactions ON (transactions.to_address = contracts.address)
WHERE contracts.is_erc721 = TRUE
GROUP BY contracts.address
ORDER BY tx_count DESC
LIMIT 10
Thanks,
Santhosh A