AlibabaResearch / AlibabaResearch/DAMO-ConvAI

Question 180 wrong meaning

Abierto
#218 0 comentarios 1 reacción 0 asignados Ver en GitHub
Lenguaje dominante
Python
Estrellas
1.6k
Forks
250
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

"db_id": "financial",

"Please provide a list of clients who were born between 1983 and 1987 and whose account branch is in East Bohemia, along with their IDs."

Grammatically, the sentence reads: "Please provide a list of clients... along with their IDs." * The word "their" refers back to the subject, which is "clients." and not to the account id.

There for the following query is wrong:

"SELECT T1.client_id, T3.account_id FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN disp AS T4 ON T1.client_id = T4.client_id INNER JOIN account AS T3 ON T2.district_id = T3.district_id and T4.account_id = T3.account_id WHERE T2.A3 = 'east Bohemia' AND STRFTIME('%Y', T1.birth_date) BETWEEN '1983' AND '1987'"

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.