Confuse about Group By Labeling about spider HOT 2 CLOSED

Hi Zecheng,

These questions are a little bit confusing if there are some singers with the exact same name. In most of the cases, we group the result by primary key. We require our annotators to select the column name which the SQL groups by. They might group by the name instead of the primary key if the question asking for the names.

Best,
Tao

from spider.

Hi, @taoyds , may I ask when will group the result by primary key, and when will group the result by the selected column name? From the training data, it seems hard to find pattern. That's maybe the reason why Group By clause (no having) has a low accuracy.

from spider.