Como Usar Sql

/*
SQLyog Enterprise - MySQL GUI v6.56
MySQL - 5.0.45-community-nt : Database - facturacion
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;CREATE DATABASE /*!32312 IF NOT EXISTS*/ facturacion /*!40100 DEFAULT CHARACTER SET latin1 */;

USE facturacion ;

/*Table structure for table articulos */

DROP TABLE IF EXISTS articulos ;

CREATE TABLE articulos (
ID_ART varchar(6) NOT NULL,
DES_ART varchar(80) NOT NULL,
MARCA varchar(20) NOT NULL,
PAIS varchar(20) default NULL,
STOCK int(10) NOT NULL,
PVP_ARTdouble(10,2) NOT NULL,
PCO_ART double(10,2) NOT NULL,
EX_MAX int(10) NOT NULL,
EX_MIN int(10) NOT NULL,
PRIMARY KEY (ID_ART)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
`
/*Data for the table articulos */

LOCK TABLES articulos WRITE;

insert into articulos(ID_ART,DES_ART,MARCA,PAIS,STOCK,PVP_ART,PCO_ART,EX_MAX,EX_MIN) values (AR0001,TELEVISOR FLATRON XS32SONY','SONY','JAPON',45,2500.50,1800.00,50,5),('AR0002','REFRIGERADORA ECASA 16 PIES FAMILIA','ECASA','ECUADOR',25,1100.25,950.25,30,8),('AR0003','LICUADORA 5 VELOCIDADES OSTER','OSTER','CHILE',54,125.50,78.00,60,10),('AR0004','DVD LG SGX134','LG','INDONESIA',50,180.50,150.50,60,15),('AR0005','DVD S34E SONY','SONY','JAPON',30,220.56,195.25,45,10),('AR0006','LAVADORA LG16LLG','LG','INDONESIA',25,850.50,705.50,45,15),('AR0007','LAVADORA ELECTROLUX 18XLBL','ELECTROLUX','USA',45,950.45,790.00,60,10),('AR0008','COCINA INDURAMA ROMA','INDURAMA','CHILE',0,650.25,520.20,30,10),('AR0009','COCINA INDURAMA VENECIA','INDURAMA','CHILE',26,780.50,595.25,45,15),('AR0010','TELEVISOR PHILLIPS 27PP','PHILLIPS','USA',35,950.60,780.45,60,15),('AR0011','TELEVISOR AYWA52HD','AYWA','JAPON',30,2150.50,1900.25,60,10),('AR0012','EQUIPO DE SONIDO SONY 8000WPS','SONY','JAPON',50,1350.50,990.50,60,10),('AR0013','EQUIPO DE SONIDO AYWA 7500 PMP','AYWA','JAPON',52,1050.50,780.26,60,15),('AR0014','LICUADORA 8 VEL BLACK AND DECKER','BLACK&DECKER','CANADA',48,85.48,58.45,50,10),('AR0015','PROCESADOR DE ALIMENTOS OSTER','OSTER','CHILE',45,98.00,80.25,50,15),('AR0016','TOSTADORA XS15OSTER','OSTER','CHILE',36,45.00,35.50,45,15),('AR0017','TELEVISOR SAMSUNG 42P','SAMSUNG','KOREA',30,1850.50,1500.00,45,10),('AR0018','REFRIGERADORA ELECTROLUX NF21','ELECTROLUX','CHILE',20,1050.75,850.50,35,10),('AR0019','MICROONDAS LG XRT12','LG','INDONESIA',15,250.50,158.90,35,10),('AR0020','MICROONDAS OSTER OM12WW','OSTER','CHILE',17,180.25,154.25,25,10),('AR0021','GRABADORA SONY 300WWSN300','SONY','JAPON',25,350.00,330.00,50,10),('AR0022','GRABADORA LG 500WLG','LG','INDONESIA',24,420.00,395.50,60,10),('AR0023','PROCESADOR DE ALIMENTOS BD','BLACK&DECKER','CANADA',15,105.50,89.65,50,10),('AR0024','TOSTADORA OSTER OS50','OSTER','CHILE',35,85.50,70.50,60,10),('AR0025','BATIDORA OSTER 15VOS','OSTER','CHILE',45,105.50,90.00,50,10);

UNLOCK TABLES;

/*Table structure for table clientes */

DROP TABLE IF EXISTSclientes ;

CREATE TABLE clientes (
ID_CLI varchar(6) NOT NULL,
NOM_CLI varchar(30) NOT NULL,
APE_CLI varchar(30) NOT NULL,
DIR_CLI varchar(80) NOT NULL,
CER_CLI varchar(13) NOT NULL,
TEL_CLI varchar(9) default NULL,
CEL_CLI varchar(9) default NULL,
SEX_CLI varchar(9) NOT NULL,
EMA_CLI varchar(100) default NULL,
SAL_CLI double(10,2) NOT NULL,FEC_ING date NOT NULL,
PRIMARY KEY ( ID_CLI )
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table clientes */

LOCK TABLES clientes WRITE;

insert into clientes ( ID_CLI , NOM_CLI , APE_CLI , DIR_CLI , CER_CLI , TEL_CLI , CEL_CLI , SEX_CLI , EMA_CLI , SAL_CLI , FEC_ING ) values ('CL0001','MIGUEL EDUARDO','MEDINA RODRIGUEZ','AV JAVIER SOTO Y OLMEDO (SANTA...