Prem

mistral-large

Max Tokens Limit for generated tokens in a chat, constrained by the model's context length (value 0 means no limit).

Temperature Sets randomness level (0 to 1). Higher values increase randomness; lower values focus output. (Default: 1)

System Prompt The system prompt sets the initial context and direction for the model's responses. It should be carefully selected to align with the specific topic and desired style of the conversation.

You are an expert in SQL. You can understand and write complex SQL queries. You will be given some plain text as a questions and you are required to generate SQL query from that. Do not generate anything else.
codellama-70b-instruct

Max Tokens Limit for generated tokens in a chat, constrained by the model's context length (value 0 means no limit).

Temperature Sets randomness level (0 to 1). Higher values increase randomness; lower values focus output. (Default: 1)

System Prompt The system prompt sets the initial context and direction for the model's responses. It should be carefully selected to align with the specific topic and desired style of the conversation.

You are an expert in SQL. You can understand and write complex SQL queries. You will be given some plain text as a questions and you are required to generate SQL query from that. Do not generate anything else.
claude-3-opus

Max Tokens Limit for generated tokens in a chat, constrained by the model's context length (value 0 means no limit).

Temperature Sets randomness level (0 to 1). Higher values increase randomness; lower values focus output. (Default: 1)

System Prompt The system prompt sets the initial context and direction for the model's responses. It should be carefully selected to align with the specific topic and desired style of the conversation.

You are an expert in SQL. You can understand and write complex SQL queries. You will be given some plain text as a questions and you are required to generate SQL query from that. Do not generate anything else.
gpt-4o

Max Tokens Limit for generated tokens in a chat, constrained by the model's context length (value 0 means no limit).

Temperature Sets randomness level (0 to 1). Higher values increase randomness; lower values focus output. (Default: 1)

System Prompt The system prompt sets the initial context and direction for the model's responses. It should be carefully selected to align with the specific topic and desired style of the conversation.

You are an expert in SQL. You can understand and write complex SQL queries. You will be given some plain text as a questions and you are required to generate SQL query from that. Do not generate anything else.

Prompt: Identify the number of genetically modified ingredients in dishes served at 'Green Leaf'?
Context: CREATE TABLE dishes_gm (dish_id INT, name VARCHAR(50), gm_ingredients INT); INSERT INTO dishes_gm VALUES (1, 'Tofu Stir Fry', 0); INSERT INTO dishes_gm VALUES (2, 'Chickpea Salad', 0); CREATE TABLE served_at (dish_id INT, location VARCHAR(50)); INSERT INTO served_at VALUES (1, 'Green Leaf'); INSERT INTO served_at VALUES (2, 'Green Leaf');
SQL:

mistral-large

codellama-70b-instruct

claude-3-opus

gpt-4o