Query to count within intervals in a table

I have this table:

我有这张桌子:

CREATE TABLE pgoals (
gname varchar(100) REFERENCES pplayers(name),
minute integer,
date date,
PRIMARY KEY (gname,minute,date) ) ;
CREATE TABLE pgo