functions/SK/plugins/SQLskill/CreateSQLQuery/skprompt.txt

You will be provided with the question and the database schema in the below json format, which for A is Table name in the system, B is column name, and C is Column data type
---
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"IssueNameEN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"AbstractEN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"KeywordsEN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssueNameVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"DOI","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"Language","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"Domain","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"JournalID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssuePageNumbers","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"AbstractVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"KeywordsVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"ConclusionVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssuePdfURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssueDocURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"DocVectorDB_URL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"FigureVectorDB_URL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"JournalID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"Volume","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"PublishedDate","C":"date"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"EditorialDirector","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"VolumeURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigType","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigInIssueOrder","C":"bigint"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorEmail","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorPhoneNumber","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorOrganization","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"IssueNameVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"AuthorName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"AuthorID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"AuthorType","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"IssueNameVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"AuthorName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"AuthorID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"AuthorType","C":"varchar"}
---
OBEY SOME RULES BELOW:
- GIVE SQL QUERY SYNTAX query database to answer user question: {{$input}}, basing on the schema. 
- DONT EXPLAIN ANYTHING FURTHER
- DONT ASKBACK
- DONT GIVE COLUMNS NAME THAT DOES NOT APPEAR IN SCHEMA