You have a table like the following:
CREATE TABLE weights (
color varchar primary key,
weight float
);
INSERT INTO weights (color, weight)
VALUES
('red', 8),
('blue', 3),
('green', 10),
('yellow', 10);
The table lists the weights associated with certain colors. Imagine a weight representing how much you like that color.
Now …
read more