请教一下 图中的sql应该如何去写

第三问题的sql 有点懵逼,还请各位指点

目测lz是进不了招商银行咯。

CREATE TABLE Group

(

GRP_NBR CHAR(10) PRIMARY KEY NOT NULL,

GRP_NAM VARCHAR(64) NOT NULL,

REG_DTE DATE NOT NULL,

USER_CNT INT NOT NULL

);

INSERT INTO USER (USER_NBR,STU_NAM ,STU_COD ,STU_AGE )VALUES ('10000001','dahuilang', 'M', '25')
INSERT INTO USER (USER_NBR,STU_NAM ,STU_COD ,STU_AGE )VALUES ('10000002','xiaohongmao', 'F', '15')