Using 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:
  • First Name
  • Last Name
  • Avatar
  • Bank Balance
• Using the CAST function to return the bank balance column as an integer.

[ID: cfc-2f4-764a]

Query

SELECT

AnswerAS 'First Name'

, AnswerAS 'Last Name'

, Answer AS 'Avatar'

, CAST(bank_balanceAnswerINTEGER) AS Answer

FROM

Answer