Drawing business conclusions

In this section, we'll use our ML model, and we'll understand how many times the BigQuery ML model is able to classify the trees well in the classification_table table.

Let's execute the following query to calculate how many times the predicted species is congruent with the actual one:

SELECT COUNT(*)
FROM (
      SELECT
        tree_id,
        actual_label,
        predicted_label_probs,
        predicted_label
      FROM
        ML.PREDICT (MODEL `10_nyc_trees_xgboost.xgboost_classification_model_version_3`,
          (
          SELECT
       ...