-- Hint: use Ctrl+Enter for SQL autocomplete
CREATE TABLE users (`id` INTEGER,
`name` VARCHAR(5),
`value` VARCHAR(3),
`user_id` INTEGER
);
INSERT INTO users
(`id`, `name`, `value`, `user_id`)
VALUES
('1', 'foo', '40', '10'),
('2', 'bar', '15', '10'),
('3', 'baz', '390', '10'),
('4', 'quux', 'ENG', '10'),
('5', 'waldo', '1', '10'),
('6', 'foo', '20', '13'),
('7', 'bar', '15', '13'),
('8', 'waldo', '1', '13'),
('9', 'baz', '0', '13'),
('10', 'quux', 'ENG', '13'),
('11', 'baz', '420', '15'),
('12', 'waldo', '1', '15'),
('13', 'bar', '1', '15'),
('14', 'foo', '5', '15'),
('15', 'quux', 'ENG', '15'),
('16', 'waldo', '1', '16'),
('17', 'quux', 'ENG', '16'),
('18', 'foo', '5', '16'),
('19', 'baz', '0', '16'),
('20', 'bar', '15', '16');
CREATE VIEW view_name AS
SELECT `name`
FROM users
;
Telegram: DB developers channel