Question

I have no experience with SQL and I need to write commands to query the following:

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.

I've watched Khanacademy videos and tried some other online tutorials but I just cannot find the information or help I need to finish this assignment. I'm in an HIM program, but that is not an option on the course info below.

Answer 1

List all patients with the last name of “Johnson”.

Select *from tablename where last name = "Johnson"

Note: tablename - mention database table name
last name- mention field name


List all patients who are female.

Select *from tablename where gender = "female"

tablename- use your own table name
gender - use your field name


List all patient last names and the medical record number of each.

Select lastname, medicalrecord from tablename

lastname- use your field name
medicalrecord- use your field name

tablename- use your tablename