테이블 간 자료추출에 대해서.. 제일 밑에 질문있습니다!

create table 음식점
 (
  가게번호 CHAR(7) NOT NULL,
  상호명 VARCHAR(20),
   연락처 VARCHAR(12),
   영업시작시간 TIME,
   영업종료시간 TIME,
   최소배달금액 INTEGER,
   동 VARCHAR(10),
   시 VARCHAR(10),
   구 VARCHAR(10),
   상세주소 VARCHAR(50),
   별점 INTEGER,
   배달료 INTEGER,
   배달시간 INTEGER,
   PRIMARY KEY (가게번호));

create table 회원
(
고객번호 VARCHAR(9) NOT NULL,
연락처 VARCHAR(11),
ID VARCHAR(20),
이름 VARCHAR(10),
등급 VARCHAR(10),
동 VARCHAR(10),
시 VARCHAR(10),
구 VARCHAR(10),
상세주소 VARCHAR(50),
PRIMARY KEY (고객번호));

create table 음식
(
메뉴번호 VARCHAR(10) NOT NULL,
음식명 VARCHAR(20),
종목 VARCHAR(10),
칼로리 INTEGER,
평균별점 INTEGER,
PRIMARY KEY (메뉴번호));

create table 배달원
(
사원번호 VARCHAR(5) NOT NULL,
배달수단 VARCHAR(12),
이름 VARCHAR(12),
연락처 VARCHAR(12),
PRIMARY KEY (사원번호));

CREATE TABLE 요청
(
사원번호 VARCHAR(5) NOT NULL,
가게번호 CHAR(7) NOT NULL,
픽업시간 INTEGER,
PRIMARY KEY (사원번호,가게번호));

CREATE TABLE 주문1
(
고객번호 VARCHAR(9) NOT NULL,
가게번호 CHAR(7) NOT NULL,
주문번호 VARCHAR(13) NOT NULL,
PRIMARY KEY (고객번호,가게번호,주문번호));

CREATE TABLE 주문2
(
주문번호 VARCHAR(13) NOT NULL,
주문일시 DATETIME,
요청사항 VARCHAR(30),
수량 INTEGER,
결제수단 VARCHAR(10),
배달시간 INTEGER,
최종결제가격 INTEGER,
PRIMARY KEY (주문번호));

CREATE TABLE 조리
(
메뉴번호 VARCHAR(10) NOT NULL,
가게번호 CHAR(7) NOT NULL,
조리시간 INTEGER,
수량 INTEGER,
PRIMARY KEY (메뉴번호,가게번호));

CREATE TABLE 리뷰
(
메뉴번호 VARCHAR(10) NOT NULL,
고객번호 VARCHAR(9) NOT NULL,
내용 VARCHAR(30),
별점 INTEGER,
시간 DATE,
PRIMARY KEY (메뉴번호,고객번호));

INSERT INTO 음식점 (가게번호,상호명,연락처,영업시작시간,영업종료시간,최소배달금액,동,시,구,상세주소,별점,배달료,배달시간)
VALUES ('0420012','유가네닭갈비','0428216674','12:00:00','23:30:00',13000,'장대동','대전광역시','유성구','320-12',4,3000,15),
('0421313','설빙','0428223382','12:00:00','23:00:00',12000,'괴정동','대전광역시','서구','313-2',4,2000,20),
('0425675','한솥','0428202141','07:00:00','22:10:00',12000,'월평동','대전광역시','유성구','120-2',3,3000,25),
('0427543','롯데리아','0428232074','08:00:00','23:30:00',12000,'궁동','대전광역시','유성구','30-4',3,2000,15),
('0422038','버거킹','0428277255','08:00:00','23:30:00',11000,'궁동','대전광역시','유성구','126-21',4,3000,15),
('0429812','공화춘','0428018773','11:30:00','23:30:00',13000,'궁동','대전광역시','유성구','36-12',3,3000,15),
('0423851','서브웨이','0421077215','08:30:00','22:30:00',10000,'월평동','대전광역시','유성구','17-1',4,2000,25),
('0423021','짜짜라이','0428721236','12:00:00','23:50:00',11000,'장대동','대전광역시','유성구','35-1',4,3000,20),
('0428874','99파스타','0424874631','12:00:00','22:30:00',6000,'월평동','대전광역시','유성구','75-12',5,4000,15),
('0429852','LA갈비집','0420846125','12:00:00','21:15:00',23000,'장대동','대전광역시','유성구','20-12',4,3000,20),
('0429798','떡튀순맛집','0429565821','08:00:00','20:30:00','9000','죽동','대전광역시','유성구','45-18',5,'2500','15'),
('0422212','마카마카롱','0426452118','09:30:00','20:00:00','12000','궁동','대전광역시','유성구','240-7',3,'5000','20'),
('0421178','엄마손집밥','0425543215','10:50:00','22:00:00','8000','궁동','대전광역시','유성구','441-3',5,'0','20'),
('0429982','노꾼꼬치','0424497858','17:00:00','03:30:00','20000','장대동','대전광역시','유성구','18-2',4,'3000','20'),
('0429211','이삭토스트','0427785331','12:00:00','22:00:00','10000','궁동','대전광역시','유성구','20-7',4,'2000','25'),
('0422080','커피장인','0423312880','13:00:00','21:30:00','12000','죽동','대전광역시','유성구','117-2',4,'1500','20'),
('0421310','홍대돈까스','0427978252','11:30:00','22:00:00','10000','궁동','대전광역시','유성구','320-5',3,'1500','15'),
('0422230','고래떡볶이','0423199972','16:30:00','22:00:00','10000','장대동','대전광역시','유성구','337-2',4,'2000','20'),
('0428980','장인마라탕','0425580671','17:30:00','23:30:00','18000','궁동','대전광역시','유성구','121-20',4,'1500','15'),
('0429919','봉구스밥버거','0426996220','11:00:00','22:00:00','15000','궁동','대전광역시','유성구','71-7',5,'2000','15');

INSERT INTO 회원 (고객번호,연락처,ID,이름,등급,동,시,구,상세주소)
VALUES ('201738425','01066748685','MUYAHO12','김가브리엘','실버','궁동','대전광역시','유성구','와이즈빌603호'),
('201735122','01064218475','TT2174EE7','성동일','골드','궁동','대전광역시','유성구','동일아파트 505호'),
('201537725','01061656875','LOVEKOREA','신성호','골드','월평동','대전광역시','유성구','월평빌203호'),
('201931158','01016151892','BANGBANG4','박호준','골드','월평동','대전광역시','유성구','와우빌105호'),
('201936682','01063633475','HANBATUNIV','김효동','브론즈','궁동','대전광역시','유성구','유성빌503호'),
('201822475','01060002005','ORIENTAL','김지석','실버','장대동','대전광역시','유성구','푸르지오1204호'),
('201996015','01021122285','GANGGANG','유재석','실버','장대동','대전광역시','유성구','롯데빌705호'),
('201971005','01061133835','KAKAOBANK','이광수','골드','장대동','대전광역시','유성구','주공아파트205호'),
('201799721','01063588852','LOVESAMSUNG','송지효','골드','궁동','대전광역시','유성구','지효빌208호'),
('201830087','01087886852','GOGIJUSEYO','하하','실버','궁동','대전광역시','유성구','하하빌902호'),
('202018770','01055282632','Baedaldal','지석진','실버','궁동','대전광역시','유성구','구름빌 202호'),
('201618491','01083439231','mangokick','현수주','브론즈','덕명동','대전광역시','유성구','드림하우스 302호'),
('201839231','01034290123','valkaie','김신악','골드','봉명동','대전광역시','유성구','탐라빌 201호'),
('202117341','01092010231','helical','김아차','브론즈','갈마동','대전광역시','서구','푸르지오 1203호'),
('201239211','01034935283','screwbar','김상원','실버','계산동','대전광역시','유성구','오투그란데 504호'),
('201433211','01093210334','babambap','이상규','브론즈','봉명동','대전광역시','유성구','애플빌 207호'),
('201930211','01095235263','mandosuk','김병지','실버','덕명동','대전광역시','유성구','하영빌라 309호'),
('202015231','01029145263','sanggood','안필립','브론즈','궁동','대전광역시','유성구','e스마트빌 505호'),
('201928191','01050443826','doitnow','송민영','실버','장대동','대전광역시','유성구','BOB빌 702호'),
('202038121','01036804121','bulkup','송영철','브론즈','갈마동','대전광역시','서구','대동빌 909호');

INSERT INTO 음식 (메뉴번호,음식명,종목,칼로리,평균별점)
VALUES ('0420012131','닭갈비','한식',430,4),
('0421313997','인절미설빙','한식',330,4),
('0425675132','치킨마요덮밥','한식',520,5),
('0427543121','데리버거세트','한식',800,5),
('0422038008','머쉬룸와퍼세트','한식',750,5),
('0429812121','숯불짜장','한식',530,4),
('0423851007','이탈리안BMT','한식',330,4),
('0423021910','삼선짬뽕','한식',680,3),
('0428874402','로제해물파스타','한식',670,4),
('0429852005','갈비','한식',500,2),
('0429798004','떡튀순세트','분식','800',4),
('0422212991','마카롱세트','디저트','480',4),
('0421178009','제육덮밥','한식','500',4),
('0429982004','새우꼬지세트','일식','700',4),
('0429211922','햄치즈토스트','분식','550',4),
('0422080110','아메리카노','디저트','5',5),
('0421310200','돈까스정식','한식','730',5),
('0422230112','로제떡볶이','한식','900',4),
('0428980910','리얼마라탕','중식','1000',3),
('0429919001','애봉이버거','분식','400',4);

INSERT INTO 배달원 (사원번호,배달수단,이름,연락처)
VALUES ('11592','오토바이','김덕배','01094216652'),
('11111','오토바이','이상원','01015641234'),
('11112','오토바이','이기원','01097791234'),
('11113','오토바이','신덕배','01097852625'),
('11114','오토바이','백종원','01018691845'),
('11115','오토바이','이설화','01018189696'),
('11116','오토바이','김기덕','01021214343'),
('11117','오토바이','백장수','01079794646'),
('21111','자전거','오기무','01065331614'),
('21112','자전거','지가우','01065621614'),
('21113','자전거','장시우','01022907997'),
('31111','도보','이재하','01066067997'),
('31112','도보','안재하','01050361141'),
('31114','도보','김창현','01096974321'),
('41111','자동차','이동훈','01088957456'),
('41112','자동차','유재익','01099774456'),
('41113','자동차','김재우','01011226655'),
('41114','자동차','오장수','01077778888'),
('51111','퀵보드','이주원','01078945123'),
('51112','퀵보드','박지원','01098132624');

INSERT INTO 요청 (사원번호,가게번호,픽업시간)
VALUES ('11592','0420012',10),
('11111','0421313',10),
('11112','0425675',5),
('11113','0427543',15),
('11114','0422038',7),
('11115','0429812',9),
('11116','0423851',6),
('11117','0423021',3),
('21111','0428874',4),
('21112','0429852',8),
('21113','0429798',9),
('31111','0422212',10),
('31112','0421178',3),
('31114','0429982',8),
('41111','0429211',5),
('41112','0422080',8),
('41113','0421310',13),
('41114','0422230',26),
('51111','0428980',21),
('51112','0429919',31);

INSERT INTO 주문1 (고객번호,가게번호,주문번호)
VALUES ('201738425','0420012','0420012001'),
('201738425','0420012','0420012131552'),
('201735122','0421313','0421313997225'),
('201537725','0425675','0425675132992'),
('201931158','0427543','0427543121110'),
('201936682','0422038','0422038008131'),
('201822475','0429812','0429812121110'),
('201996015','0423851','0423851007334'),
('201971005','0423021','0423021910882'),
('201799721','0428874','0428874402112'),
('201830087','0429852','0429852005110'),
('202018770','0429798','0429798004331'),
('201618491','0422212','0422212991881'),
('201839231','0421178','0421178009110'),
('202117341','0429982','0429982004112'),
('201239211','0429211','0429211922646'),
('201433211','0422080','0422080110997'),
('201930211','0421310','0421310200110'),
('202015231','0422230','0422230112197'),
('201928191','0428980','0428980910877'),
('202038121','0429919','0429919001050');

INSERT INTO 주문2 (주문번호,주문일시,요청사항,수량,결제수단,배달시간,최종결제가격)
VALUES ('0420012131552','14:45:05','빨리 와주세요.' ,1,'카드',20,18000),
('0421313997225','15:58:02','젓가락 가져다 주세요.',2,'카드',20,19000),
('0425675132992','16:25:02','조심히 와주세요.',3,'현금',20,   35000),
('0427543121110','17:05:06','조심히 와주세요.',1,'카드',10,   20000),
('0422038008131','19:47:32','일회용기로 가져다주세요.',1,'카드',15,19000),
('0429812121110','19:48:05','조심히 와주세요.',1,   '현금',35,   18500),
('0423851007334','13:54:45','일회용기로 가져다주세요.',1,'카드',60,17000),
('0423021910882','20:50:41','조심히 와주세요.',1,   '카드',40,   16000),
('0428874402112','21:10:10','조심히 와주세요.',1,   '카드',20,   15000),
('0429852005110','16:26:25','일회용기로 가져다주세요.',1,'카드',30,16000),
('0429798004331','15:31:10','조심히 와주세요.',1,   '카드',15,   20000),
('0422212991881','16:25:20','조심히 와주세요.',1,   '현금',20,   21000),
('0421178009110','17:52:20','일회용기로 가져다주세요.',2,'카드',30,42000),
('0429982004112','12:20:40','조심히 와주세요.',2,   '카드',30,35000),
('0429211922646','13:48:48','조심히 와주세요.',2,   '카드',40,24600),
('0422080110997','15:32:41','젓가락 가져다 주세요.',5,'카드',30,78000),
('0421310200110','16:21:21','조심히 와주세요.',1,'카드',15,30000),
('0422230112197','16:21:47','젓가락 가져다 주세요.',1,'현금',30,15000),
('0428980910877','19:52:01','조심히 와주세요.',1,'카드',25,17000),
('0429919001050','18:10:00','조심히 와주세요.',1,'현금',30,16000);

INSERT INTO 조리 (메뉴번호,가게번호,조리시간,수량)
VALUES ('0420012131','420012',20,1),
('0421313997','421313',10,2),
('0425675132','425675',15,3),
('0427543121','427543',16,1),
('0422038008','422038',40,1),
('0429812121','429812',13,1),
('0423851007','423851',21,1),
('0423021910','423021',27,1),
('0428874402','428874',40,1),
('0429852005','429852',50,1),
('0429798004','429798',10,1),
('0422212991','422212',20,1),
('0421178009','421178',30,2),
('0429982004','429982',30,2),
('0429211922','429211',30,2),
('0422080110','422080',20,5),
('0421310200','421310',10,1),
('0422230112','422230',15,1),
('0428980910','428980',25,1),
('0429919001','429919',35,1);

INSERT INTO 리뷰 (메뉴번호,고객번호,내용,별점,시간)
VALUES ('0420012131','201738425','맛이 아주 좋습니다',5,'2021-06-04'),
('0421313997','201735122','맛이 깔끔해요',4,'2021-06-04'),
('0425675132','201537725','배달이 빨라요',4,'2021-06-05'),
('0427543121','201931158','위생이 깨끗해요',5,'2021-06-05'),
('0422038008','201936682','많이 매워요',4,'2021-06-05'),
('0429812121','201822475','양이 많아서 좋아요',4,'2021-06-05'),
('0423851007','201996015','음식이 다 식어서 왔어요',3,'2021-06-06'),
('0423021910','201971005','맛이 없어요',1,'2021-06-06'),
('0428874402','201799721','튀김이 눅눅해요',2,'2021-06-06'),
('0429852005','201830087','국물이 샜어요',3,'2021-06-06'),
('0429798004','202018770','매콤하니 맛있어요',4,'2021-06-06'),
('0422212991','201618491','국물이 시원해요',4,'2021-06-06'),
('0429982004','201839231','해산물이 싱싱해요',3,'20221-06-06'),
('0429211922','201433211','머리카락이 빠져있어요',3,'2021-06-06'),       
('0422080110','201930211','튀김이 바삭해요',4,'2021-06-06'),
('0421310200','202015231','배달이 빨라요',3,'2021-06-06'),
('0422230112','201928191','배달원분이 친절해요',4,'2021-06-06'),
('0428980910','202038121','양이 푸짐해요',4,'2021-06-06');

select 주문일시
From 주문2

이런식으로 되어있는데 자료를 추출 할 때
주문2와 조리에서 조리시간과 배달시간을 합치고싶은데
테이블 간에 어떻게 자료를 합칠까요 ㅠㅠ
sum 을 사용해서 where구문을 사용해야하나요? 조언부탁드립니다
커피라도 한잔 보내드리겠습니다...