Pharma Marketing
SQL
Data Loading
People & Culture
Fun Facts
100

This regulation requires that health information is protected and handled with confidentiality 

What is HIPAA?

100

This is what every SQL command ends with

What is a semicolon?

100

You use this when separating DOB into year/month/day

What is CSV stay?

100

These mentors biked across Italy earlier this year

Who are Emily & Kristen?
100
This event happens every Friday morning

What is Breakfast Club?

200

This type of condition is persistent or long-lasting in nature (>3 months) 

What is chronic?

200

This SQL function combines two tables

What is a join?

200

This extra field is added in order to keep all responses in a response file

What is "dedupe" key?

200

This Crossix employee used to live in Japan and now lives in Seattle 

Who is Whitney?

200

This Crossix organized sports team plays games throughout the fall

What is the Crossix softball team?

300

This marketing tactic includes in-office media

What is POC (Point of Care)? 
300

This statement is used to return only unique values

What is distinct? (select distinct)

300

This is what you add to a list that already exists in the vault (the pieces that make up a list)

What is a segment? 

300

This Crossix employee traveled to Russia for the World Cup last month

Who is Naru?

300

Including the Class of 2018, Crossix now has this many employees

What is 148?

400

This type of campaign aims to raise awareness for a certain condition and is typically less expensive 

What is unbranded?

400

This word indicates that a field is not filled out

What is null?

400

These keys are used to dedupe the demographic file

What is 1.) Person ID

            2.) First name, Last name, Address, Zipcode?

400

This Crossix employee is getting married this weekend

Who is Adam Dubrow?

400

New hires put on a skit at this office party every year

What is the holiday party?

500

This government regulation requires that pharma companies include risks and side effects alongside benefits in their advertisements

What is fair balance?

500

This character helps you search using parts of a word

What is % (wild card)?

500

This is the name for a predefined field

What is a canonical field?

500

This Crossix employee lived and worked in London for several years

Who is Andy?

500

This is the most controversial office snack

What are Runts?

M
e
n
u