Question $5$: $\backslash ((20\backslash \%)\backslash )$ Medical records. These contain confidential information, so privileges need to be set carefully. In case an accident victim arrives at a hospital, they may need to know blood type, and whether a tetanus shot $($injection of vaccine$)$ is up to date. $($It is good for $10$ years, flu shots for $1$ year$)$ It would also be a good idea to remind people when they need booster shots.

Most people in Quebec have a num$$ro d'assurance maladie $($noam $-$ it's actually $4$ letters and $8$ digits$)$ Here is a schema for this question:

people $($noam$,$ name, spouse$\_$name, address, postalcode, birthdate$)$ vaccines $($kind$,$ years$\_$good$)$

shots $($noam$,$ date, kind$)$

bloodtype $($noam$,$ date, type$)--$ determined when you donate blood, or work in a hospital

Write SQL queries for these:

$1.$ Victim has cut his hand with a with a utility knife, probably needs stitches. Is his tetanus shot up to date? noam$=$'JENL $12345678\text{'}$

$($and it was $2$ days before my daughter's wedding. $-$ use scissors instead$)$

$2.$ You just got a Covid shot today. That should go in the database. An insert statement, please.

$3.$ How many people got a flu shot since September $1,2022?$

$4.$ We want to send a reminder to everyone who needs a new shot $($Previous one becomes no longer good today$),$ except flu shots, you need one every fall.

Note: Assume years$\_$good is stored as type interval, which can be added to date, and compared with another date.