Obtaining a MIN() value in a column in a subquery
From your post:

INSERT INTO PC    
(model, speed, ram)
VALUES
(1070, 2.00, 1024, --- Missing closing parenthesis ')'
(1071, 2.10, 512),
(1050, 1.90, 512);


Once that was corrected, your query worked for me.