Question: Submit your solutions as a single .sql file These questions concern the computing products relations. a) Find the model numbers of all of the PCs

Submit your solutions as a single .sql file

Submit your solutions as a single .sql file These questions concern the

These questions concern the computing products relations. a) Find the model numbers of all of the PCs that share a speed with another PC. b) Find the model numbers of all of the PCs that don't share a speed with another PC. c) Give the model numbers of all of the pairs of PCs that share a hard drive size, along with that hard drive size. Each pair of model numbers should appear in the final list exactly once. In other words, if [1001, 1002, 250] appears in the list, then [1002, 1001, 250] should not. Hint: You may want to think about what condition you could place in the WHERE so that only pairs where the smaller of the model numbers is listed first will appear

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!