Calhoun international Interview Questions

Overview

calhoun international, llc is a department of veteran affairs center for veterans enterprise (cve) certified service disabled veteran-owned, small business. founded in 2005, calhoun international is headquartered in tampa, florida, with presence in florida, maryland, texas, virginia, washington dc, and overseas locations. service offerings include: intelligence operations and analysis, fraud analysis and investigations, threat finance analysis, cyberspace analytic support, information technology, irregular warfare analysis, strategic planning, counterterrorism analysis, and operational research systems analysis. additional information may be found at www.calhouninternational.com

Calhoun international Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(10)
SQL
(4)
Behavioral
(4)
Data Structures & Algorithms
(3)
A/B Testing
(1)

Challenge

Check your skills...
How prepared are you for working at Calhoun international?

Calhoun international Interview Questions

Practice for the Calhoun international interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Hard

The schema below is for a retail online shopping company consisting of two tables, attribution and user_sessions.

  • The attribution table logs a session visit for each row.

  • If conversion is true, then the user converted to buying on that session.

  • The channel column represents which advertising platform the user was attributed to for that specific session.

  • Lastly the user_sessions table maps many to one session visits back to one user.

First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.

Calculate the first touch attribution for each user_id that converted. 

Example:

Input:

attribution table

Column Type
session_id INTEGER
channel VARCHAR
conversion BOOLEAN

user_sessions table

column type
session_id INTEGER
created_at DATETIME
user_id INTEGER

Example output:

user_id channel
123 facebook
145 google
153 facebook
172 organic
173 email
A/B Testing
Hard
SQL
Easy
Loading pricing options

View all Calhoun international questions

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion