Find the name and savings balance of the top 3 accounts with the highest saving balance sorted by savings balance in descending order.
CREATE TABLE savings (balance VARCHAR, custid VARCHAR); CREATE TABLE accounts (name VARCHAR, custid VARCHAR)
SELECT TOP 3 T1.name, T2.balance FROM accounts AS T1 JOIN savings AS T2 ON T1.custid = T2.custid ORDER BY T2.balance DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE savings (balance VARCHAR, custid VARCHAR); CREATE TABLE accounts (name VARCHAR, custid VARCHAR) Question: Find the name and savings balance of the top 3 accounts with the highest saving balance sorted by savings balance in descending order. [/INST] SELECT TOP 3 T1.name, T2.balance FROM accounts AS T1 JOIN savings AS T2 ON T1.custid = T2.custid ORDER BY T2.balance DESC </s>