What am I doing wrong?

[FMastro]

I've installed WrenAI and have it running locally to a local MS SQL database. I mapped out tables and realtionships in the model builder, but it seems I can't get any good results in my questions. For example I have a table called Unit and each unit has a type value of 1, 2, 3. 1 is project, 2, is workload, 3 is location. I want to be able to ask, how may projects do I have? and it knows to count the units with type A that are isactive=true. Or how many locations are in Texas? and based on seeing a unit has an address figure that out. But when I ask, it seems to never get it right or it spits me back sql query syntax and how I can get that info myself.

What am I doing wrong and how can I train it? Thank you.

[cyyeh]

@FMastro what llm are you using?

[cyyeh]

Welcome to join Discord and I can discuss with you to help you out, and you share screen with me

https://discord.gg/5DvshJqG8Z