human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: P, Player, League, Scottish Cup, League Cup, Challenge Cup, Total
###Question: What is bryan hodge's player number
gpt
SELECT COUNT P FROM table WHERE Player = Bryan Hodge