Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started