如何为每个团队计算三个不同的百分比

Here is my sample data

这是我的样本数据

CREATE TABLE Grades
([Team] varchar(10),[Grade] Integer, [Target] Integer);

INSERT INTo Grades VALUES ('A',26,25);
INSERT INTo Grades VALUES ('A',13,35);
INSERT INTo Grades VALUES ('A',13,15);
INSERT INTO Grades VALUES ('B',10,20);
INSERT INTo Grades VALUES ('B',13,11);
INSERT INTO Grades VALUES ('C',20,30);
CREATE TABL