oracle的统计查询语句,请用sql语句实现对下面oracle数据库表的查询统计

drop table order_tab

create table order_tab(

id varchar2(32) not null primary key,

name varchar2(20),

dress varchar2(20),

tel varchar2(20),

shop varchar2(100),

log varchar2(100),

fp varchar2(20),

jer number,

jf number(1),

quan number(1),

shop_time Date

)

drop table detail_tab

create table detail_tab(

id varchar2(32) not null primary key,

order_id varchar2(32),

name varchar2(20),

jg number,

sj_jg number,

cou number,

foreign key(order_id) references order_tab(id)

)

select *

from order_tab o,detail_tab d

where o.id='10005600091'

select id

from order_tab

where shop='格力电器旗舰店'

select o.id,o.name,o.dress

from order_tab o,detail_tab d

where o.id=d.order_id and d.name='美的2018-23电压力锅'

select o.id,o.name,o.dress

from order_tab o,detail_tab d

where o.id=d.order_id and d.name='美的2018-23电压力锅' and to_char(shop_time-1,'dd')=18

select *

from order_tab o,detail_tab d

where o.id=d.order_id and o.name='张华' and MONTHS_BETWEEN(sysdate, shop_time)=1