Loblaw Companies Limited Interview Questions

Loblaw Companies Limited Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(10)
SQL
(3)
Forecasting & Time Series
(3)
Analytics
(3)
Business Case
(3)

Loblaw Companies Limited Interview Questions

Practice for the Loblaw Companies Limited interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).

Example:

Input:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

products table

Column Type
id INTEGER
name VARCHAR
price FLOAT

users table

Column Type
id INTEGER
name VARCHAR
sex VARCHAR

Output:

Column Type
month INTEGER
num_customers INTEGER
num_orders INTEGER
order_amt INTEGER
Product Sense & Metrics
Hard
Machine Learning
Hard
Loading pricing options

View all Loblaw Companies Limited questions

Challenge

Check your skills...
How prepared are you for working at Loblaw Companies Limited?

Loblaw Companies Limited Salaries by Position

Marketing Analyst*
$60K
Marketing Analyst
Median: $60K
Mean (Average): $60K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Marketing Analyst role pays the most with a $60,000 base salary while the Marketing Analyst role on average pays the least with a $60,000 base salary.

Discussion & Interview Experiences

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