-- create a table
CREATE TABLE cliente (
  Id_cliente INTEGER PRIMARY KEY,
  Nombre_Cliente TEXT NOT NULL,
  ciudad TEXT NOT NULL,
  Pais TEXT NOT NULL,
  N_Ventas INTEGER NOT NULL
);
-- insert some values
INSERT INTO cliente VALUES (1, 'Ana García','Madrid','España',120 );
INSERT INTO cliente VALUES (2, 'Luis Pérez','Barcelona','España',85 );
INSERT INTO cliente VALUES (3, 'María López','Valencia','España',200 );
INSERT INTO cliente VALUES (4, 'Carlos Ruiz','Madrid','España',45 );
INSERT INTO cliente VALUES (5, 'Elena Torres','Sevilla','España',67 );
INSERT INTO cliente VALUES (6, 'John Smith','London','UK',150 );
INSERT INTO cliente VALUES (7, 'Marie Dubois','Paris','Francia',92 );
INSERT INTO cliente VALUES (8, 'Hans Müller','Berlin','Alemania',78 );
INSERT INTO cliente VALUES (9, 'Luis Pérez','Barcelona','España',85 );
INSERT INTO cliente VALUES (10, 'Sofia Anders','Stockholm','Suecia',55 );
-- fetch some values
SELECT * 
FROM cliente
WHERE Nombre_Cliente LIKE '%ez';