Clase 30-12-2024

¿Qué instrucción selecciona todas las columnas de la tabla bigquery-public-data.crypto_bitcoin.transactions?

• • SELECT all FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT columns FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT ALL COLUMNS FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cómo seleccionas únicamente las columnas size y block_number de la tabla?

• SELECT size AND block_number FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT size, block_number FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT {size, block_number} FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT size OR block_number FROM bigquery-public-data.crypto_bitcoin.transactions

¿Qué consulta renombra la columna size como transaction_size?

• • SELECT size AS transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT size RENAME transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT size, transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cómo calculas el promedio del tamaño de las transacciones (size) en la tabla?

• • SELECT AVERAGE(size) FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT AVG(size) FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT MEAN(size) FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT AVG OF size FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cuál consulta devuelve el número total de transacciones en la tabla?

• • SELECT COUNT(*) FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT SUM(*) FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT TOTAL(*) FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT COUNT(ALL) FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cómo ordenas las transacciones por tamaño (size) de forma descendente?

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions ORDER BY size

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions SORT BY size DESC

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions ORDER BY size DESC

• 1. SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions SORT DESC BY size

¿Cómo seleccionas las transacciones con un tamaño mayor a 500 bytes?

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions WHERE size > 500

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions FILTER size > 500

• • SELECT size > 500 FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT * WHERE size > 500 FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cuál consulta agrega un alias a la suma del valor de entrada (input_value)?

• • SELECT SUM(input_value) RENAME total_input_value FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT SUM(input_value) AS total_input_value FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT total_input_value AS SUM(input_value) FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT total_input_value = SUM(input_value) FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cómo agrupas las transacciones por el mes del bloque (block_timestamp_month) y calculas el promedio del tamaño?

• • SELECT block_timestamp_month, AVG(size) GROUP BY block_timestamp_month FROM bigquery-public-data.crypto_bitcoin.transactions

• • SELECT AVG(size), block_timestamp_month FROM bigquery-public-data.crypto_bitcoin.transactions GROUP BY block_timestamp_month

• • SELECT block_timestamp_month, AVG(size) FROM bigquery-public-data.crypto_bitcoin.transactions GROUP BY block_timestamp_month

• 1. SELECT block_timestamp_month AVG(size) GROUP BY block_timestamp_month FROM bigquery-public-data.crypto_bitcoin.transactions

¿Cómo seleccionas las 10 transacciones con el mayor valor de salida (output_value)?

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions ORDER BY output_value LIMIT 10

• • SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions ORDER BY output_value DESC LIMIT 10

• • SELECT TOP 10 output_value FROM bigquery-public-data.crypto_bitcoin.transactions

• 1. SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions LIMIT 10 ORDER BY output_value DESC