Technical

Query an order table to find the total revenue by country for a given year. Break down the results by month as well.

Business Intelligence Engineer

Amazon Web Services

Did you come across this question in an interview?

Your answer

Try Free AI Interview

Google logo

Google

Product Manager

Prepare for success with realistic, role-specific interview simulations.

Product Strategy
Meta logo

Meta

Product Manager

Prepare for success with realistic, role-specific interview simulations.

Product Sense
Meta logo

Meta

Engineering Manager

Prepare for success with realistic, role-specific interview simulations.

System Design
Amazon logo

Amazon

Data Scientist

Prepare for success with realistic, role-specific interview simulations.

Behavioral
  • Query an order table to find the total revenue by country for a given year. Break down the results by month as well.
  • Can you write a query to calculate total revenue by country for a specific year, broken down by month?
  • How would you pull monthly revenue totals by country for a given year from an orders dataset?
  • Given a table of orders, write a query to get revenue per country per month for a selected year.
  • Write a SQL query to show how revenue is distributed across countries and months for a specific year.
  • How would you generate a report of monthly revenue per country for a particular year using order data?
  • From an order table, how can you find country-wise total revenue for each month in a specified year?
  • Suppose you're analyzing global sales — how would you break down revenue by country and month for a certain year?
  • Show how you'd use SQL to get monthly sales numbers by country for any given year.
  • How would you approach finding the revenue per country per month for a selected year using an orders table?
  • Write a query that gives monthly and country-level revenue summaries for a particular year.

Interview question asked to Business Intelligence Engineers interviewing at Amazon Web Services: Query an order table to find the total revenue by country for a given year. Break down the results by month as well..