CLASE 2 SQL

CREATE DATABASE claseDOS;

USE clase2;

SHOW TABLES;

CREATE TABLE articulos(
    id INT auto_increment,
    nombre varchar(255),
    precio float (7,2),
    cantidad INT (3),
    primary key (id)
    );

CREATE TABLE clientes(
    DNI INT not null,
    nombre varchar(255),
    primary key (DNI)
    );

CREATE TABLE facturas(
    id INT auto_increment,
    codigo varchar(3),
    precio float (7,2),
    primary key (id,codigo)
    );


DROP TABLE articulos;
DROP TABLE clientes;
DROP TABLE facturas;


INSERT INTO articulos VALUE ('','MAUSE',200,50),
                            ('','TECLA2',245,20),
                            ('','IMPRESORA',100,30),
                            ('','GABINE3',70,80),
                            ('','MONITOR',200,50);

INSERT INTO clientes VALUE  (36181522,'JORGE'),
                            (40585966,'LUIS'),
                            (26585955,'GERARDO'),
                            (74858922,'MARTA'),
                            (10205688,'CARLOS');

INSERT INTO facturas VALUE  ('','A21',350),
                            ('','V20',2220),
                            ('','C30',350),
                            ('','A21',806),
                            ('','C23',5077);

SELECT * FROM articulos;
SELECT * FROM clientes;
SELECT * FROM facturas;

SELECT * FROM articulos
WHERE (precio>100);

SELECT * FROM articulos
WHERE (20<precio AND 200>precio);

SELECT * FROM articulos
WHERE precio between 20 and 200;