nnarodytska

**Updated (one more inconsistency was found):** "question_id": 99 has a possible incorrect ground truth SQL query : Q: Among the accounts who have loan validity more than 12 months, list...

"question_id": 95 has an incorrect ground truth SQL query: Q: "List out **the account numbers** of clients who are youngest and have highest average salary?", A (SQL): `"SELECT T1.account_id FROM...

**Incorrect description of database "financial".** **Issue:** `A4-A7 are specified as text but their types are integers (as A8's type). ` The type makes a difference when we order by any...

_"question_id": 118 has an incorrect ground truth SQL query:_ Q: "For loan amount less than USD100,000, what is the percentage of accounts that is still running with no issue.", E...

_"question_id": 141 has an incorrect ground truth SQL query:_ Q: "Which districts have transactions greater than USS$10,000 in 1997?", A (SQL): "`SELECT T1.district_id FROM account AS T1 INNER JOIN district...

_"question_id": 143 has an incorrect ground truth SQL query:_ Q: "What are the accounts that have **both gold and junior credit cards**?", A (SQL): `"SELECT T2.account_id FROM card AS T1...

_"question_id": 145 has an incorrect ground truth SQL query:_ Q: "Who are the account holder identification numbers **whose spent per month** on the credit card is less than the average,...

_"question_id": 162 has an incorrect ground truth SQL query:_ Q: "What is **the region** of the client with the id 3541 from?" A (SQL): ` "SELECT T2.district_id, T1.A3 FROM district...

_"question_id": 163 has a possible incorrect ground truth SQL query:_ Q: "Which district has the most accounts with loan contracts finished with no problems?" A (SQL): `"SELECT T1.district_id FROM district...

_"question_id": 180 has an incorrect ground truth SQL query:_ Q: "Please provide a list of clients who were born between 1983 and 1987 and whose account branch is in East...