Bits and byte

Question

 

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

Answer 1

The error depends on author imo don't consider the error