BigQuery -如何查找特定输出地址的BitCoin输入地址

Question

BigQuery公共数据集: Crypto_Bitcoin

我一直在尝试识别将比特币发送到特定地址(例如XXX)的所有唯一输入(发送方)地址。尽管感觉这是一个基于数据库模式的简单查询，但尽管进行了无数次尝试，我还是收到了错误。谁能帮我找出这里的问题是什么：

SELECT DISTINCT inputs.addresses FROM bigquery-public-data.crypto_bitcoin.transactions as transactions, transactions.inputs as inputs WHERE outputs.addresses = "XXX"

谢谢

Data Schema

Answer 1

下面是针对BigQuery标准SQL的说明

请在下面尝试

SELECT DISTINCT input_address
FROM `bigquery-public-data.crypto_bitcoin.transactions` AS transactions, 
  transactions.inputs AS input, input.addresses AS input_address,
  transactions.outputs AS output, output.addresses AS output_address
WHERE output_address = "XXX"