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

Question:

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

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

b. SELECT City, LastName, Balance WHERE City='Waterville' AND Balance>1000;

c. SELECT City, LastName, Balance FROM Patient WHERE City="Waterville" AND Balance>1000;

d. SELECT *

FROM Patient WHERE City='Waterville' AND Balance>1000; PatientNum LastName FirstName Koehler King Houghland Falls Odepaul Venable Waggoner 1010 1011 1012 1013. 1014