Write the SQL code for the following: List the last name, city, and balance of patients who

Question:

Write the SQL code for the following: List the last name, city, and balance of patients who live in Waterville or have a balance greater than $2,000.

a. SELECT LastName, City, Balance FROM Patient WHERE City='Waterville' AND Balance>2000;

b. SELECT LastName, City, Balance FROM Patient WHERE City='Waterville' OR Balance>=2000;

c. SELECT LastName, City, Balance FROM Patient WHERE NOT City='Waterville' OR Balance>2000;

d. SELECT LastName, City, Balance FROM Patient WHERE City="Waterville" OR Balance>2000;PatientNum LastName FirstName Koehler King Houghland Falls Odepaul Venable Waggoner 1010 1011 1012 1013. 1014

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: