drop table orderx
/
drop table menux cascade constraint
/
drop sequence menux_s
/
drop sequence orderx_s
/
create sequence menux_s
/
create sequence orderx_s
/
create table menux(
           id number(6),
           mname varchar2(10) not null,
            price number(6),
            constraint menux_id_pk primary key(id)
 )
/

create table orderx(
           id number(6),
           su number(4) not null,
           menu_id number(6),
           constraint orderx_id_pk primary key(id),
           constraint orderx_menu_id_fk foreign key(menu_id)
                   references menux(id)
)
/


insert into menux values(menux_s.nextval,'자장면',3500)
/

insert into menux values(menux_s.nextval,'짬뽕',4000)
/

insert into menux values(menux_s.nextval,'탕수육',12000)
/

commit
/

insert into orderx values(orderx_s.nextval,2,1)
/

insert into orderx values(orderx_s.nextval,4,2)
/

insert into orderx values(orderx_s.nextval,1,3)
/

insert into orderx values(orderx_s.nextval,2,2)
/

commit
/

select o.id, m.mname menuName, m.price*o.su TotalPrice
from orderx o join menux m on(o.menu_id = m.id)
/