sing the Examples database in SSMS or SQL Azure, write a SQL query to satisfy the requirements below.

Accuracy is important. The full query must execute properly and return the expected result when the exact values you insert below are substituted for the blanks.

Tip: Type out the entire query in SSMS or SQL Azure and test it thoroughly before submitting.

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.

Query

Answer

AnswerAS Answer , last_name AS 'Last Name' , Answer AS 'Balance'

FROM

Answer

WHERE

Answer

ORDER BY

Answer , Answer