SQL Error about Group by

taoyds / spider

scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge

https://yale-lily.github.io/spider

Apache License 2.0

848 stars 193 forks source link

SQL Error about Group by #13

Closed GaoyanCheerup closed 5 years ago

GaoyanCheerup commented 5 years ago

For example, How many actors have appeared in each musical? why Group by "T1.Musical_ID" instead of "T2.Name". SELECT T2.Name , COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID GROUP BY T1.Musical_ID

taoyds commented 5 years ago

Hi,

Thanks for your report! We will look into these examples and update them in the later version if we think they are wrong as well.

Best, Tao