trying to incorporate the query titled "free throws made" as a subquery into the query below it titled "FreeThrowPercByGame" but getting an error. Both work independent of each other in Google Big Query. Thank you.

```
--free throws made
  select  scheduled_date,
        home_market,
    away_market,
    team_name,
    count( *)FreeThrowMade,
    FROM
    `bigquery-public-data.ncaa_basketball.mbb_pbp_sr` gamestbl
    WHERE season IN (2017)
    AND (home_market IN ("Ohio State")
      OR away_market IN ("Ohio State"))
    AND event_type IN ("freethrowmade")
    AND period in (1,2)
    AND team_name IN ("Buckeyes")
    group by 
    scheduled_date,
        home_market,
    away_market,
    team_name
      ORDER BY
    scheduled_date asc

--FreeThrowPercByGame
    select
    scheduled_date,
    home_market,
    away_market,
    team_name,
    count(event_type IN ("freethrowmiss","freethrowmade"))NoOfFTAttempts
    FROM
    `bigquery-public-data.ncaa_basketball.mbb_pbp_sr` gamestbl
    WHERE
    season IN (2017)
    AND (home_market IN ("Ohio State")
      OR away_market IN ("Ohio State"))
    AND event_type IN ("freethrowmiss","freethrowmade")
    AND period in (1,2)
    AND team_name IN ("Buckeyes")
    group by 
    scheduled_date,
        home_market,
    away_market,
    team_name
      ORDER BY
    scheduled_date asc

```