   is_partitioning_column = 'YES' OR clustering_ordinal_position IS NOT NULL;
 
 
--- QUERY 5
+-- QUERY 4
 -- Question: If you wanted to query across multiple datasets, how could you do it?
 -- https://stackoverflow.com/questions/43457651/bigquery-select-tables-from-all-tables-within-project
--- Answer: With a UNION or a python script to iterate through each dataset in `bq ls`
+-- Answer: With a UNION (or a Python script) to iterate through each dataset in `bq ls`
+
+-- For example, which table has the most rows?
 
 WITH ALL__TABLES__ AS (
   SELECT * FROM `bigquery-public-data.baseball.__TABLES__` UNION ALL

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


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

SELECT * FROM 

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



-- EXAMPLE QUERY FOR YOUR OWN PROJECT
-- Note that this query will not run on the BigQuery Public Dataset project but it will run in your own project
-- Identify the most recently modified datasets in project 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
 `project-name.INFORMATION_SCHEMA.SCHEMATA` AS s
 LEFT JOIN `project-name.INFORMATION_SCHEMA.SCHEMATA_OPTIONS` AS so
 USING (schema_name)
 
ORDER BY last_modified_time DESC

LIMIT 15;
