Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Active Customer List by City

Easy

JoinsData WranglingAggregations

Problem

Task

You are given a customer table from an Eli Lilly commercial analytics environment and asked to write a SQL query that returns the number of active customers in each city. Your result should include the city and the count of active customers, sorted by the customer count in descending order and then by city name ascending. Use only the customers table.

Problem

Task

You are given a customer table from an Eli Lilly commercial analytics environment and asked to write a SQL query that returns the number of active customers in each city. Your result should include the city and the count of active customers, sorted by the customer count in descending order and then by city name ascending. Use only the customers table.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Dell Technologies

Extract Active Customer Contact DataEasy

KARL STORZ

Retrieve KARL STORZ Customer RecordsEasy

PNC Financial Services Group

Top Customer Cohorts by RevenueEasy

Active Customer List by City | Dataford Interview Questions