Se han creado las tablas CUSTOMERS y

ORDERS a través se las siguientes sentencias CREATE TABLE:

 CREATE TABLE customers

(custid varchar2(5), companyname varchar2(30),

contactname varchar2(30), address varchar2(30),

city varchar2(20), state varchar2(30),

phone varchar2(20), constraint pk_customers_01 primary key (custid));

CREATE TABLE orders

(orderid varchar2(5) constraint pk_orders_01 primary key,

orderdate date, total number(15),

custid varchar2(5) references customers (custid));

Se pide que muestres un informe con los

pedidos (