Sailor (Sid––––,Sname,Age)
Reserves (Sid,Bid–––––––––,date)
Boat (Bid––––,Bname,color)
i) Select B.bid, count (*) From boat B, Reserves R
Where R.bid = B.bid and B.color = 'Red' Group By B.bid
ii) Select B.bid, count (*) From boat B, Reserves R
Where B.bid = R.bid Group By B.bid having B.color = 'Red'
iii) Select B.bid, count (*) From boat B, Reserves R
Where B.bid = R.bid Group By B.bid, B.color having B.color = 'Red'
Which of the following is a true statement?
A
Query (ii) and Query (iii) gives the same result
B
Query (i) and Query (ii) gives the same result
C
Query (i) and Query (iii) gives the same result
D
Query (iii) results an error