-- Database schema
| all_prevalences : ITEM [ TEXT ] primary_key , POPULATION TYPE [ TEXT ] , OCCURRENCES [ INTEGER ] , POPULATION COUNT [ INTEGER ] , PREVALENCE RATE [ REAL ] , PREVALENCE PERCENTAGE [ REAL ] | patients : patient [ TEXT ] primary_key , birthdate [ DATE ] , deathdate [ DATE ] , ssn [ TEXT ] , drivers [ TEXT ] , passport [ TEXT ] , prefix [ TEXT ] , first [ TEXT ] , last [ TEXT ] , suffix [ TEXT ] , maiden [ TEXT ] , marital [ TEXT ] , race [ TEXT ] , ethnicity [ TEXT ] , gender [ TEXT ] , birthplace [ TEXT ] , address [ TEXT ] | encounters : ID [ TEXT ] primary_key , DATE [ DATE ] , PATIENT [ TEXT ] encounters.PATIENT = patients.patient , CODE [ INTEGER ] , DESCRIPTION [ TEXT ] , REASONCODE [ INTEGER ] , REASONDESCRIPTION [ TEXT ] | allergies : START [ TEXT ] , STOP [ TEXT ] , PATIENT [ TEXT ] allergies.PATIENT = patients.patient , ENCOUNTER [ TEXT ] allergies.ENCOUNTER = encounters.ID , CODE [ INTEGER ] , DESCRIPTION [ TEXT ] | careplans : ID [ TEXT ] , START [ DATE ] , STOP [ DATE ] , PATIENT [ TEXT ] careplans.PATIENT = patients.patient , ENCOUNTER [ TEXT ] careplans.ENCOUNTER = encounters.ID , CODE [ REAL ] , DESCRIPTION [ TEXT ] , REASONCODE [ INTEGER ] , REASONDESCRIPTION [ TEXT ] | conditions : START [ DATE ] , STOP [ DATE ] , PATIENT [ TEXT ] conditions.PATIENT = patients.patient , ENCOUNTER [ TEXT ] conditions.ENCOUNTER = encounters.ID , CODE [ INTEGER ] , DESCRIPTION [ TEXT ] conditions.DESCRIPTION = all_prevalences.ITEM | immunizations : DATE [ DATE ] , PATIENT [ TEXT ] immunizations.PATIENT = patients.patient , ENCOUNTER [ TEXT ] immunizations.ENCOUNTER = encounters.ID , CODE [ INTEGER ] , DESCRIPTION [ TEXT ] | medications : START [ DATE ] , STOP [ DATE ] , PATIENT [ TEXT ] medications.PATIENT = patients.patient , ENCOUNTER [ TEXT ] medications.ENCOUNTER = encounters.ID , CODE [ INTEGER ] , DESCRIPTION [ TEXT ] , REASONCODE [ INTEGER ] , REASONDESCRIPTION [ TEXT ] | observations : DATE [ DATE ] , PATIENT [ TEXT ] observations.PATIENT = patients.patient , ENCOUNTER [ TEXT ] observations.ENCOUNTER = encounters.ID , CODE [ TEXT ] , DESCRIPTION [ TEXT ] , VALUE [ REAL ] , UNITS [ TEXT ] | procedures : DATE [ DATE ] , PATIENT [ TEXT ] procedures.PATIENT = patients.patient , ENCOUNTER [ TEXT ] procedures.ENCOUNTER = encounters.ID , CODE [ INTEGER ] , DESCRIPTION [ TEXT ] , REASONCODE [ INTEGER ] , REASONDESCRIPTION [ TEXT ] | claims : ID [ TEXT ] primary_key , PATIENT [ TEXT ] , BILLABLEPERIOD [ DATE ] , ORGANIZATION [ TEXT ] , ENCOUNTER [ TEXT ] , DIAGNOSIS [ TEXT ] , TOTAL [ INTEGER ] |
-- -- How many patients with shellfish allergies died when they were under 12 years old? Please give their full names.

SELECT T1.first, T1.last FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Shellfish allergy' AND CAST((strftime('%J', T1.deathdate) - strftime('%J', T1.birthdate)) AS REAL) / 365 < 12;