Leads and Partners per Day

#391

For each date_id and make_name, count the number of distinct leads and distinct partners. Return date_id, make_name, unique_leads, and unique_partners.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

date_id	make_name	unique_leads	unique_partners
2020-12-07	honda	3	2
2020-12-07	toyota	1	2
2020-12-08	honda	2	2

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid