create table Orders(order_id varchar(10), customer_id varchar(10), hotel_id varchar(10), partner_id varchar(10), order_date date, order_amount int);

insert into Orders values('OP001', 'C1001', 'H01', 'P001', '08-JAN-2022', 500);
insert into Orders values('QR002', 'D2001', 'I02', 'Q002', '09-MAR-2022', 400);
insert into Orders values('ST003', 'E3001', 'J03', 'R003', '17-FEB-2022', 250);
insert into Orders values('UV004', 'F4001', 'K04', 'S004', '29-JAN-2022', 300);
insert into Orders values('WX005', 'G5001', 'L05', 'T005', '13-MAR-2022', 410);
insert into Orders values('YZ006', 'H6001', 'M06', 'U006', '01-FEB-2022', 299);

select * from Orders;