Cacher is the code snippet organizer for pro developers

CREATE TABLE categories(
		id INT AUTO_INCREMENT NOT NULL,
		name VARCHAR(60) NOT NULL,
		PRIMARY KEY (id)
);
INSERT INTO categories(name) VALUES('old stock');
INSERT INTO categories(name) VALUES('new stock');
INSERT INTO categories(name) VALUES('modern');
INSERT INTO categories(name) VALUES('commercial');
INSERT INTO categories(name) VALUES('recyclable');
INSERT INTO categories(name) VALUES('executive');

CREATE TABLE providers(
		id INT AUTO_INCREMENT NOT NULL,
		name VARCHAR(60) NOT NULL,
		street VARCHAR(60) NOT NULL,
		city VARCHAR(60) NOT NULL,
		estate VARCHAR(2) NOT NULL,
		PRIMARY KEY (id)
);

INSERT INTO providers(name, street, city, estate) VALUES('Henrique', 'Av. Brasil', 'Rio de Janeiro', 'RJ');
INSERT INTO providers(name, street, city, estate) VALUES('Marcelo Augusto', 'Rua Imigrantes', 'Belo Horizonete', 'MG');
INSERT INTO providers(name, street, city, estate) VALUES('Caroline Silva', 'Av. São Paulo', 'Salvador', 'BA');
INSERT INTO providers(name, street, city, estate) VALUES('Guilherme Staff', 'Rua Central', 'Porto Alegre', 'RS');

CREATE TABLE products(
		id INT AUTO_INCREMENT NOT NULL,
		name VARCHAR(60) NOT NULL,
		amount DOUBLE PRECISION NOT NULL,
		price DOUBLE PRECISION NOT NULL,
		id_providers INT,
		id_categories INT,
		PRIMARY KEY (id)
);

INSERT INTO products(name, amount, price, id_providers,id_categories) VALUE('Two-door wardrobe', 100, 800, 6, 8);
INSERT INTO products(name, amount, price, id_providers,id_categories) VALUE('Dining table', 1000, 560, 1, 9);
INSERT INTO products(name, amount, price, id_providers,id_categories) VALUE('Towel holder', 10000, 25.50, 5, 1);
INSERT INTO products(name, amount, price, id_providers,id_categories) VALUE('Computer desk', 350, 320.50, 4, 6);
INSERT INTO products(name, amount, price, id_providers,id_categories) VALUE('Chair', 3000, 210.64, 3, 6);
INSERT INTO products(name, amount, price, id_providers,id_categories) VALUE('Single bed', 750, 460, 1, 2);

SELECT prod.name as name, prov.name as name
FROM products prod, providers prov, categories cat
WHERE prod.id_categories = 6
AND prov.id = prod.id_providers
AND cat.id = 6
ORDER BY prod.name DESC;