model creating own column name
#50
by
abeotttyy
- opened
I used the following prompt:
prompt=f"""
Task
Generate a MSSQL query to answer the following question: What is the age of Smith?
Database Schema
This query will run on a database whose schema is represented in this string:
Table 'students' ##\n\nSchema:\n('StudentID', 'AutoField')\n('FirstName', 'TextField')\n('LastName', 'TextField')\n('Age', 'IntegerField')
SQL
Given the database schema, here is the SQL query that answers What is the age of Smith?:
"""
I am getting the following sql
SELECT s.age FROM students AS s WHERE s.last_name = 'Smith'
LastName ------------->> changed to ------------------->>last_name
Temp solution, Lower all the characters
LastName------->>lastname