• Elizabeth Gilbert 17
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hi, 
I am trying to complete the "Query GitHub Data Using Big Query" project and on the thrid step am encountering the error "Invalid Table" regarding the script that I am cutting and pasting directly from the exercies. I bolded it below. Does anyone know how old the exercise is, and if the table name has been changed? Thank you.


#standardSQL
SELECT subject, COUNT(*) AS num_duplicates
FROM `bigquery-public-data.github_repos.commits`
GROUP BY subject
ORDER BY num_duplicates
DESC LIMIT 100
The Error I get is: "Step Not yet complete... here's what's wrong: 
Please check that your report includes at least all of these columns: Supply: Supply Name, Unit Cost, Quantity and Total. 
Note: you may run into errors if you've skipped previous steps."

this is my report:
my Report
not sure where I made a mistake