in Databases edited by
498 views
1 vote
1 vote

 the table “Sales89” contains information about the address,zip,sale-date,price and inflamation-adjusted “real-price” of 222 sales of single family homes in calcutta during 1989.Here is the table schema

in Databases edited by
498 views

4 Comments

Answer will be B.

this query grouping rows on the basis of address. So if in table for same address you will get two sales in same year then that will come in the result and on the basis of number of sales ordering is defined means higher number of sales of same property will come first then lower than that and so on.

And brother edit this question in text. because it will be helpful in future for searching purpose.
1
1

on the basis of number of sales ordering is defined.

How did you get this?

0
0
See if you carefully analyze this query count(*) is nothing but  number of unique sale id's for a group of same addresses. but you can argue that there is possibility that sales_id can be duplicate so group by always removes duplicates.
1
1

1 Answer

0 votes
0 votes
Best option will be option B as address isn’t valid parameter for the count.