Geo-targeting Project [23-25]
We will look at the volumes sold and the sales generated for each configuration to decide which configuration to promote:
create table config as
select configuration, count(*) as num_sold, sum(price) as total_sales
group by configuration
order by total_sales desc;
Did the code fail?
Copy and run the code below to create the input data sets.
The configurations are sorted by total revenue generated in descending order: