 -- Querying dataset metadata
 -- https://cloud.google.com/bigquery/docs/dataset-metadata
 
--- QUERY 1
--- Most recently modified BigQuery Public Datasets and how long they have been around:
-SELECT
- s.*,
- TIMESTAMP_DIFF(CURRENT_TIMESTAMP(), creation_time, DAY) AS days_live,
- option_value AS dataset_description
-FROM
- `bigquery-public-data.INFORMATION_SCHEMA.SCHEMATA` AS s
- LEFT JOIN `bigquery-public-data.INFORMATION_SCHEMA.SCHEMATA_OPTIONS` AS so
- USING (schema_name)
-
-WHERE so.option_name = 'description'
- 
-ORDER BY last_modified_time DESC
-
-LIMIT 15;
-
 -- Advanced example: Using Dataset and Table metadata to create SQL DDL for version control
 -- https://cloud.google.com/bigquery/docs/information-schema-tables#advanced_example
 
 
--- QUERY 2
--- Querying table metadata to get table size
--- Pick any dataset in the bigquery-public-dataset and tell me
+-- QUERY 1
+-- Query table metadata to get table size
+-- Pick any dataset in the bigquery-public-dataset and tell me:
 
 -- How many tables it contains?
--- What is the largest table in GB?
--- What is the largest table in row count?
+-- What is the largest table in terms of GB?
+
+-- Dataset options include: bitcoin_blockchain, github_repos, nasa_wildfire, wikipedia, and more
 
 SELECT 
   dataset_id,

ORDER BY row_count DESC -- Top 10 tables with the most rows
LIMIT 10;

-- Which table was it? 

  `bigquery-public-data.baseball.__TABLES__`
ORDER BY size_gb DESC;

-- Modify the query above to determine:
-- What is the largest table in terms of row count?
-- Is the same table as the largest in terms of GB?


-- QUERY 2
-- For the dataset you chose, how many columns of data are present?

SELECT * FROM 
