Exercise: 1 Find the model number, speed and hard drive capacity for all the PCs with prices below $500. Result set: model, speed, hd. Solution SELECT model, speed, hd FROM PC WHERE price < 500