You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We got very performance since the model answers the question with some sentence not related to SQL command, e.g.
To find the number of employees hired in each shop, you can use the following SQL command:
SELECT s.Name, COUNT(e.Employee_ID) AS Num_Employees
FROM shop s
JOIN hiring h ON s.Shop_ID = h.Shop_ID
JOIN employee e ON h.Employee_ID = e.Employee_ID
GROUP BY s.Name;
This command joins the shop table with the hiring table on the Shop_ID column, and then joins the resulting table with the employee table on the Employee_ID column. The COUNT function is used to count the number of employees hired in each shop, and the resulting table is grouped by the Name column of the shop table.
The resulting table will have two columns: Name and Num_Employees. The Name column will contain the name of each shop, and the Num_Employees column will contain the number of employees hired in each shop.
Could you help me to figure out where is the problem? Thanks!!!!
The text was updated successfully, but these errors were encountered:
We fine-tuned CodeLlama-7b-instruct with the provided SFT code. The configuration is as follows:
We got very performance since the model answers the question with some sentence not related to SQL command, e.g.
To find the number of employees hired in each shop, you can use the following SQL command:
This command joins the
shop
table with thehiring
table on theShop_ID
column, and then joins the resulting table with theemployee
table on theEmployee_ID
column. TheCOUNT
function is used to count the number of employees hired in each shop, and the resulting table is grouped by theName
column of theshop
table.The resulting table will have two columns:
Name
andNum_Employees
. TheName
column will contain the name of each shop, and theNum_Employees
column will contain the number of employees hired in each shop.Could you help me to figure out where is the problem? Thanks!!!!
The text was updated successfully, but these errors were encountered: