Scribd
Upload
42 views2 pages

UTHSC SQL Assignment M6 Assignment

This document outlines the preparation and exercises for Module 6 of the BMI 5300 course, focusing on SQL aggregate functions, counting, and sorting using DB Browser for SQLite. It includes specific tasks such as calculating averages, finding maximum values, and querying patient data based on various criteria. Students are required to complete exercises and record their answers before entering them into Canvas within a time limit.

Uploaded by

Garree
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
42 views2 pages

UTHSC SQL Assignment M6 Assignment

This document outlines the preparation and exercises for Module 6 of the BMI 5300 course, focusing on SQL aggregate functions, counting, and sorting using DB Browser for SQLite. It includes specific tasks such as calculating averages, finding maximum values, and querying patient data based on various criteria. Students are required to complete exercises and record their answers before entering them into Canvas within a time limit.

Uploaded by

Garree
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

BMI 5300 Introduction to Biomedical Informatics

Module 6: SQL Aggregate Functions, Counting, and Sorting


** Using DB Browser for SQLite **
Spring 2025

Preparation
1. Complete any SQL homework tutorials for this week BEFORE attempting this assignment.
2. Do the exercises and record your answers on this worksheet BEFORE opening the quiz in
Canvas.
3. You will then use this worksheet to enter your answers in Canvas. You will have 10 minutes
to enter your answers in Canvas.

Do the following exercises and write down your answers on this sheet
1. What is the average height of all patients?
[Enter only the numbers to the left of the decimal and 1 digit to the right of the decimal. For
example: for 123.456 you would enter 123.45. DO NOT round up or down.]

2. Paste your query below:

3. What is the average weight of all the female patients?


[Enter only the numbers to the left of the decimal and 1 digit to the right of the decimal. For
example: for 123.456 you would enter 123.45. DO NOT round up or down.]

4. What is the heaviest weight of all the male patients?

______________________________________________________________________________
5. What is the heaviest weight of all patients? Paste your query below:

6. What is the tallest height for all patients in the state of New York (abbreviation NY)?

7. What is the LAST name of the patient with the lowest weight in the state of Tennessee
(abbreviation TN)?

ECJ 2/6/25 Page 1 of 2


BMI 5300 Introduction to Biomedical Informatics Module 6: SQL Aggregate Functions, Counting, and Sorting

8. How many patients have a B+ blood type?


(Note 1: your query should only give you a number.)
(Note 2: Check the spelling and capitalization of the column name for blood type.)

9. Write a query that gives you just the total number of patients who have a particular blood
type. Paste your query below:

10. Run a query that shows you all the patients, with the oldest patient first.
According to the dates of birth in the database, what is the FIRST name of the oldest
patient?

11. Paste the query that shows you all the patients with the oldest patient first, and have
your results sorted.

Rev. 2/6/2025 ECJ Page 2 of 2

You might also like