Write the SQL code for the following: List the last names of patients whose balance is greater
Question:
Write the SQL code for the following: List the last names of patients whose balance is greater than $1,000.
a. SELECT LastName, Balance>1000 FROM Patient;
b. SELECT LastName, Balance FROM Patient WHERE Balance>1000;
c. SELECT LastName, Balance FROM Patient WITH Balance>1000;
d. SELECT LastName, Balance FROM Patient WHERE Balance<1000;
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Question Posted: