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

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
Get step-by-step solutions from verified subject matter experts
