SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE GOODS
(
    gID  int NOT NULL,
    gName   [nvarchar](50) NOT NULL,
    gQnty  int NOT NULL
);
CREATE TABLE ITEMS
(
    iID   int NOT NULL,
    gID  int NOT NULL,
    iItem    [nvarchar](50) NOT NULL,
    iPrice  int NOT NULL
);
insert into GOODS values
 ( 1 ,'DISH A', 10)
,( 2 ,'DISH B', 12)
,( 3 ,'DISH A', 4)
3 rows affected

insert into ITEMS values
 ( 1 ,1 ,'Sugar', 200)
,( 2 ,1 ,'Milk', 300)
,( 3 ,1 ,'Fruits', 100)
,( 4 ,2 ,'Oil', 200)
,( 5 ,3 ,'Sugar', 100)
,( 6 ,3 ,'Milk', 50)
,( 7 ,3 ,'Fruits', 40)
7 rows affected

WITH A AS (
SELECT gName, SUM(ITEMS.iPrice) AS iPrice
FROM GOODS
LEFT JOIN ITEMS
ON GOODS.gID = ITEMS.gID
GROUP BY gName 
)
SELECT gName, 
(SELECT SUM(gQnty) FROM GOODS WHERE GOODS.gName = A.gName GROUP BY gName ) AS gQnty,
iPrice
FROM A


gName
gQnty
iPrice


DISH A
14
790

DISH B
12
200