Chapter 4 case project

Question

Create a view named HighBalance using the the patient number, last name, first name, street, city and zip code for those patients with a balance greater than $1,000. Display the data in the view

Im having trouble creating this SQL command sequence, every time i try to correct it, it gives me an error message saying: Syntax error in CREATE TABLE sequence

CREATE Table HighBalance AS
SELECT PatientNum, LastName, FirstNAme, Street, City, ZipCode
FROM Patient
WHERE Balance>1000 ;

What did i do wrong?

CREATE Table --> CREATE view.

The Impaler
– The Impaler

2023-09-14 17:53:10 +00:00
Commented Sep 14, 2023 at 17:53 — The Impaler
– The Impaler, Commented Sep 14, 2023 at 17:53

Pruss · Accepted Answer · 2023-09-14 17:44:26Z

1

Perhaps FirstNAme should be FirstName? Perhaps CREATE TABLE should be CREATE VIEW?

CREATE VIEW HighBalance AS
SELECT PatientNum, LastName, FirstName, Street, City, ZipCode
FROM Patient
WHERE Balance > 1000;

Try this first:

SELECT * from Patient

If that works try:

SELECT * from Patient WHERE Balance > 1000

If that works try:

SELECT PatientNum, LastName, FirstName, Street, City, ZipCode
FROM Patient
WHERE Balance > 1000;

Then you will be closer to understanding the problem.

answered Sep 14, 2023 at 17:44

Pruss

2571 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Chapter 4 case project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related