CSC 371 Lecture Notes - Lecture 7: Hard Disk Drive, Realaudio
Document Summary
!f) find those hard-disk sizes that occur in two or more pc"s. Group by without this condition the hard disk sizes will be listed for each pc, this causes all of the hard disk sizes to be distinct. Having sure that the only sizes listed are those that are ones that occur at least twice. !g) find those pairs of pc models that have both the same speed and ram. From pc pc1 join pc pc2 on pc1. speed=pc2. speed and pc1. ram = pc2. ram. Pc pc1 this renames the table so that we can use the same table more than once pc1. model < pc2. model ensures that we do not have duplicates (ex. 10001, 10002 and 10002: or the same pc in the list. !h)find those manufacturers of at least two different computers (pc or laptops) with speed of at least 700. Having count(maker) > 2 (select you can have a statement within a statement.