Donor-to-Acceptor Ratio Query | Dataford Interview Questions

Given two tables, DONOR and ACCEPTOR, find the city with the best and worst donor-to-acceptor ratio.

Calculate the ratio as donor count divided by acceptor count. Consider only cities with at least one donor and one acceptor. Break ratio ties alphabetically by city.

Output

Return one row for each result, with columns ratio_type, city, donor_count, acceptor_count, and donor_to_acceptor_ratio.
Include exactly one best row and one worst row.
Order best before worst.

Schema

donor

Column	Type	Description
donor_idPK	INT	Unique donor identifier
city	VARCHAR(100)	Donor city

acceptor

Column	Type	Description
acceptor_idPK	INT	Unique acceptor identifier
city	VARCHAR(100)	Acceptor city

Your question is Donor-to-Acceptor Ratio Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem