Question $6$

Scenario $2,$ questions $6-10$

You$$ve been working for the nonprofit National Dental Society $($NDS$)$ as a junior data analyst for about two months. The mission of the NDS is to help its members advance the oral health of their patients. NDS members include dentists, hygienists, and dental office support staff.

The NDS is passionate about patient health. Part of this involves automatically scheduling follow$-$up appointments after crown replacement, emergency dental surgery, and extraction procedures. NDS believes the follow$-$up is an important step to ensure patient recovery and minimize infection.

Unfortunately, many patients don$$t show up for these appointments, so the NDS wants to create a campaign to help its members learn how to encourage their patients to take follow$-$up appointments seriously. If successful, this will help the NDS achieve its mission of advancing the oral health of all patients.

Your supervisor has just sent you an email saying that you$$re doing very well on the team, and he wants to give you some additional responsibility. He describes the issue of many missed follow$-$up appointments. You are tasked with analyzing data about this problem and presenting your findings using data visualizations.

An NDS member with three dental offices in Colorado offers to share its data on missed appointments. So$,$ your supervisor uses a database query to access the dataset from the dental group. The query instructs the database to retrieve all patient information from the member$$s three dental offices, located in zip code $81137.$

The table is dental$\_$data$\_$table, and the column name is zip$\_$code. You have written the following query, but received an error when it ran.

SELECT $*$

FROM dental$\_$data$\_$table

WHERE dental$\_$data$\_$table $=81137$

Given the objective of the query, where is the mistake in this query?

$1$ point

In line $3,$ dental$\_$data$\_$table should be replaced with zip$\_$code.

The third line should be WHERE $=81137$

SELECT, FROM, and WHERE should not be capitalized.

In line $2,$ dental$\_$data$\_$table should be replaced with zip$\_$code $81137.$