Honor Interview Questions

Honor Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(72)
SQL
(58)
Machine Learning
(50)
Probability
(31)
Statistics
(20)

Honor Interview Questions

Practice for the Honor 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
Behavioral
Medium
Analytics
Medium
Loading pricing options

View all Honor questions

Challenge

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

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