State SQL query to satisfy the requirements below: REQUIREMENTS Exercise 1: Include the following columns: First Name
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: