How to merge similar records in SQL?

Question

SQL

Good day, toasters!!!
Tell me how to combine two similar records in SQL?
For example, I need to display the model number, speed, and hard drive size of a PC that has 12x or 24x CDs and costs less than $600.
Did something like this:

SELECT DISTINCT model,speed, hd
 FROM PC
WHERE cd = '12x' OR cd='24x' AND price < 600

Output:
Model Speed ​​HD
1232 450 10.0
1232 450 8.0
1232 500 10.0
1232 500 5.0
1233 500 5.0
1260 500 10.0 Ah MUST
:
MODEL SPEED HD
1232 450 10.0
1232 450 8.0
1232 500 10.0
1260 500 10.0