SQL Queries HIM-650- Health Care Data Management Grand Canyon University Kaleena Moore September 29, 2018

Running Head: SQL QUERIES 1




SQL Queries

HIM-650- Health Care Data Management

Grand Canyon University

Kaleena Moore

September 29, 2018

, SQL QUERIES 2


SQL Queries

For this assignment, use the following database schema:

1) Patient—PatientID, Name, DOB

// Kaleena Moore

// HIM 650

// September 30, 2018

// This is my own work.



Sqlite> .header on

Sqlite> .mode column

CREATE TABLE Patient ( PatientID char(6) not null, Name char(15) not null, DOB date(8) not
null, PRIMARY KEY (PatientID) );

INSERT INTO Patient ( PatientID, Name, DOB) VALUES ( ‘458962’, ‘John Smith’, ‘04051985’
);

INSERT INTO Patient ( PatientID, Name, DOB) VALUES ( ‘461482’, ‘Julie
Simek’, ‘06181965’ );

INSERT INTO Patient ( PatientID, Name, DOB) VALUES ( ‘478962’, ‘Katt Nelson’,
‘11271961’ );

INSERT INTO Patient ( PatientID, Name, DOB) VALUES ( ‘432485’, ‘Bob Trump’,
‘12211951’
);