State SQL query to satisfy the requirements below:

REQUIREMENTS

Exercise 1:

Include the following columns:

• First Name
• Last Name
• Avatar
• Bank Balance
• Using theCASTfunctionto return the bank balance column as an integer.

Exercise 2:

Requirements

• Include the following columns:
  • ID
  • Last Name
  • Balance
• Return all people from the people table who have less than $200 in their bank account.
• Sort the results by bank balance and then last name.
• Round the bank balance to the nearest dollar.