Obtaining a MIN() value in a column in a subquery I have the two following tables:

CREATE TABLE PC (
    model ..., 
    speed ..., 
    ram...,
    ...
);

CREATE TABLE Laptop (
    model ..., 
    speed ..., 
    ram ..., 
    screen...,
    ...
);


And am trying to create a query that gives the model numbers of all laptops with a speed slower than that of any PC. 

I came up with:

SELECT model
FROM Laptop, (SELECT MIN(speed) AS speed FROM PC)slowpcs
WHERE Laptop.speed &lt; slowpcs.speed;


However even after double checking that I had added a laptop that meets this criterion and running the code, it's giving me an empty results list.

INSERT INTO Laptop
(model, speed, ram)
VALUES
(2006, 3.00, 2048),
(2007, 1.73, 1024),
(2009, 2.80, 512);

INSERT INTO PC
(model, speed, ram)
VALUES
(1070, 2.00, 1024,
(1071, 2.10, 512),
(1050, 1.90, 512);
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.