Exercise One: Studies Database

Open the database "Physicians$-$Datafile.accdb" posted on Moodle. It encloses information about different health related studies conducted by various physicians with different specialties. It is the same database you used in your last lab work.

The relationships between the tables are shown in the following snapshot:

Write the needed SQL queries to do the following: $($Save each query as specified $($Q$1,$ Q$2,$ Q$3...))$:

Q$1-$ The blood pressure value contains $2$ numbers: the high pressure and the low pressure, for example $120/80.$ Write the corresponding query to display the name and the blood pressure of the volunteers who have a high pressure of $170$ and a low pressure greater than or equal to $100($hint: to be greater than or equal to $100,$ it should be formed of three digits$).$ Partial snapshot:

$\backslash$table$[[$First Name,Last Na$,$BloodPressure$],[$Dallah$,$Candy,$\frac{170}{130}$