5 ms·
I can't seem to get it to correctly answer any query which references more than a single table. For instance, "which city has the most farms" yields the somewh
by antimatter15 6y ago
I can't seem to get it to correctly answer any query which references more than a single table.
For instance, "which city has the most farms" yields the somewhat nonsensical "SELECT city.City_ID FROM city GROUP BY city.City_ID ORDER BY COUNT(*) DESC LIMIT 1"
It seems fine for basic queries like "how many total horses are there", but that's basically it.
- tgb 6y agoI couldn't get it to work well either, but note that farm's don't have a city, so your question is impossible to answer.
- jon-wood 6y agoA system like this needs to be able to flag when a query can’t be answered, rather than spit some arbitrary query out instead. That’s by no means an easy feat, but bad data authoritatively delivered is worse than no data.