373 views

2 Answers

0 votes
0 votes
It should be C.

A) It will return the minumum damage of EVERYcar.

B) Incorrect Querry.

C) Is correct. It will calculate the Min (damage-amount) and will retrieve the data.
0 votes
0 votes

(C) It cannot be answer. Here condition for joining with accident A table is not given So, it will give error.

(A) Here group by clause is not need. Group by used when more than one group involved in a query. But here we only need the car getting minimum damage.

(B) This query is correct according to our need. We actually need the minimum damage car, it's owner and his address , which is fulfilling here.

So, Ans B)

Related questions

0 votes
0 votes
0 answers
3
sid2601678 asked Oct 4, 2018
1,423 views
Consider the sql querySelect p.a1 From p,r1,r2 Where p.a1 = r1.a1 or p.a1 = r2.a1Under what conditions does the preceding query select values of p.a1 that are either in r...
0 votes
0 votes
0 answers
4
ejaz asked Jul 26, 2018
267 views
http://gateoverflow.in/743/gate2001-2-25 Can someone help me to understand this one.?It tells something about one table that geq which gives the condition and it also say...