Click here to Skip to main content
14,447,769 members
Rate this:
Please Sign up or sign in to vote.
See more:
select V.vid,vmake,vmodel,vyear,oname from 
(	select vid from (select vid,count(sid) as count_sid from fillings where sid IN
		(select distinct F.sid from vehicle V join fillings F on V.vid=F.vid where F.amount>=1000 and V.oname='Ali Muneer')and amount>=1000 group by vid) as vid_count_sid
				where count_sid = 
	(SELECT count(sid)  FROM station WHERE sid IN
		(select distinct F.sid from vehicle V join fillings F on V.vid=F.vid where F.amount>=1000 and V.oname='Ali Muneer'))
)
as result join vehicle V where result.vid=V.vid;


What I have tried:

what should be the relational algebra of above query
Posted
Updated 24-Nov-19 20:04pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100