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  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: