Assignment: Data Evaluation
Using the data dictionary and data retrieval request below, write an SQL command to satisfy a data retrieval request.
Data Dictionary:
Patient Table
|
Element
|
Definition
|
Type
|
Length
|
Default
|
Constraints
|
|
MR#
|
Unique identification number
|
Numeric
|
9
|
None
|
100000000-999999999
|
|
Lname
|
Individual's Last Name
|
Alpha
|
25
|
None
|
None
|
|
Fname
|
Individual's First Name
|
Alpha
|
20
|
None
|
None
|
|
Gender
|
Individual's gender
|
Alpha
|
1
|
None
|
"F" or "M"
|
|
Bdate
|
Individual's birth date
|
Date
|
8
|
None
|
None
|
Data retrieval request:
List all patients with the last name of "Johnson".
List all patients who are female.
List all patient last names and the medical record number of each.