Set Difference Operation

Using the set difference operation

Page 1 of 1

1 Replies - 1722 Views - Last Post: 13 February 2010 - 05:12 PM Rate Topic: -----

#1 Guest_Crosby87*


Set Difference Operation

Posted 13 February 2010 - 04:22 PM


I have been working for about a week on this problem and I can't seem to get anywhere with it.


Use set difference operation to find those car owners from Pittsburgh,
whose cars demonstrate low fuel efficiency (MPG < 30)?

I am working with 2 tables Car and Car_owner

Car: Car_id, Manufature, Model, Year, MPG

Car_owner: Car_id, Name, City, State

I cannot figure out how to go about using set difference ( - ) to answer this question.

Any help is greatly appreciated.

Is This A Good Question/Topic? 0

Replies To: Set Difference Operation

#2 Guest_crosby87*


Re: Set Difference Operation

Posted 13 February 2010 - 05:12 PM

Ok, I think i may have found this one out.

Here is what I have come up with:

PROJECT car_id(car_owner) - PROJECT car_id(SELECT MPG < 30(car))

I hope I am on the right track.
Was This Post Helpful? 0

Page 1 of 1