CREATE TABLE cliente
(
    NUMcli INT not null,
    NOMcli char(30)not null,
    DIRcli char(30),
    Email char(30) DEFAULT('desconocido'),
    saldo_30 decimal (10,2),
    saldo_tot decimal (10,2),
    PRIMARY KEY (NUMcli)
);


CREATE TABLE vendedor
(
    NOMven char(30) not null,
    NUMven INT not null,
    DIRven char(30) not null,
    RFCven char(13) not null,
    EMAIL char(40) DEFAULT ('incompleto'),
    VENTASsem INT not null,
    VENDIDOSsem decimal (10,2) not null,
    PRIMARY KEY (RFCven)
);


CREATE TABLE articulos
(
    CODIGObarra INT not null,
    COLOR char(20) not null,
    TALLA char(20),
    TRANSPIRABLE char(2),
    DESCRIPCION char(20) not null,
    PRECIO decimal (5,2) not null,
    PRIMARY KEY (CODIGObarra)
);  

/*INSERT INTO articulos (CODIGObarra,COLOR,TALLA,TRANSPIRABLE,DESCRIPCION,PRECIO)
    VALUES
(1,'AZUL_MARINO','M','SI','SHORTS',300.00),
(2,'NEGRO','XS','NO','BLUSA',150.50),
(3,'CELESTE','G','NO','LEGGINGS',200.30),
(4,'ROJO','XXL','SI','SHORTS',400.20),
(5,'CELESTE','M','NO','SHORTS',220.00),
(6,'TURQUEZA','M','NO','FALDA_SHORTS',849.99),
(7,'ROSA','XS','SI','SUDADERA',500.99),
(8,'ROSA','G','SI','VESTIDO',650.90),
(9,'AMARILLO','CH','NO','SUDADERA',480.90),
(10,'ROSA','M','NO','LEGGINGS',360.00);*/


select * from articulos;
select TALLA,DESCRIPCION,PRECIO
from articulos;
select COLOR,TRANSPIRABLE, DESCRIPCION
from articulos;                            

SELECT AVG(PRECIO) AS promedio_precio FROM articulos;