For each question, you should include these

  
 

1. the question number and the question itself in full text; 2. your SQL statement; 3. query result from MySQL. For example, your answer to the first question should look like this: 1. Find the model number, speed, and hard-disk size for all PC's whose price is under $1000. SELECT model, speed, hdisk FROM pc WHERE price < 1000; | model speed | hdisk | | 1002 2.10 | 250 | 1003 1.42 | 80 | 1004 | 2.80 | 250 | 1005 3.20 250 | 1007 2.20 | 200 | | 1008 | 2.20 | 250 | | 1009 | 2.00 | 250 | | 1010 2.80 | 300 | 1011 1.86 | 160 | 1012 2.80 | 160 | | 1013 | 3.06 | 80 | 11 rows in set (0.00 sec)