Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Notice that the person with person_id 12 is associated with four distinct Simvastatin drug exposures. Write a query to show the four Simvastatin drug concepts
Notice that the person with person_id 12 is associated with four distinct Simvastatin drug exposures. Write a query to show the four Simvastatin drug concepts for the individual with person_id 12. The query result should use "drug" as the column heading for the listed drugs. Hint: start with the query above and modify it.
%%sql select drug_exposure.person_id, count(distinct drug_concept.concept_name) from drug_exposure inner join ( select concept_id, concept_name from concept where domain_id = 'Drug' and concept_name like '%Simvastatin%' ) as drug_concept on drug_exposure.drug_concept_id = drug_concept.concept_id group by drug_exposure.person_id limit 10;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started