problem in CREATE VIEW

Hello,
   how can I CREATE VIEW containing subselect in query.

   I have 2 tables

   CREATE TABLE aaa (
      id SERIAL,
      name VARCHAR(20),
      CONSTRAINT aaa_pk PRIMARY KEY (id)
   )

   CREATE TABLE bbb (
      id SERIAL,
      fk_id INTEGER NOT NULL
      counter INTEGER NOT NULL,
      CONSTRAINT bbb_pk PRIMARY KEY (id),
      CONSTRAINT aaa_fk FOREIGN KEY (fk_id)
      REFERENCES aaa(id) ON DELETE CASCADE
   )

  I would like to create follow view:

  CREATE VIEW xyz AS
                  SELECT name, (SELECT SUM(counter) FROM bbb WHERE fk_id 
= aaa_temp.id)
                                 FROM aaa AS aaa_temp
 
  but the error has occured: "Syntax error or access violation;-5010 
POS(68) Missing value specification."

  When I try to run simple select, it works OK.

  Can you help me how can I do this VIEW ?

  Thanks,
  Julian