Retrieve all accounts where the AccountType is 'Savings' and the Balance is greater than $2000 but less than $3000

To retrieve accounts based on specific criteria in a database, you would typically use a SQL (Structured Query Language) query. Here’s how you can structure that SQL statement to fetch all accounts where the AccountType is 'Savings' and the Balance is greater than $2000 but less than$3000:

SQL Query

SELECT *
FROM Accounts
WHERE AccountType = 'Savings' 
  AND Balance > 2000 
  AND Balance < 3000;

Explanation

1. *SELECT : This part of the query indicates that you want to select all columns from the records that meet your criteria.
2. FROM Accounts: This specifies the table from which you want to retrieve the data, in this case, the Accounts table.
3. WHERE Clause: This is used to apply conditions to filter the results:
   • AccountType = 'Savings': This condition filters the results to include only accounts that are of type 'Savings'.
   • Balance > 2000: This ensures that the Balance is greater than $2000.
   • Balance < 3000: This restricts the results so that the Balance is less than $3000.

Final Result

The query will return all rows in the Accounts table for accounts that are of type 'Savings' with a balance between $2000 and$3000.