HIM650 Health Care Data Management Week 4 Assignment SQL Queries - Latest 2020 complete solution Guide

Running Head: SQL QUERIES 1




SQL Queries

HIM-650- Health Care Data Management

Grand Canyon University

Kaleena Moore

September 29, 2018




This study source was downloaded by 100000835004878 from CourseHero.com on 08-15-2022 12:33:14 GMT -05:00


https://www.coursehero.com/file/34331891/KMoore-SQLQueriesdocx/

, 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’
);




This study source was downloaded by 100000835004878 from CourseHero.com on 08-15-2022 12:33:14 GMT -05:00


https://www.coursehero.com/file/34331891/KMoore-SQLQueriesdocx/