This project demonstrates advanced SQL techniques by analyzing a relational baseball database containing player, team, salary, and school information. The objective was to answer a variety of ...
SUM(CASE WHEN transaction_type = 'Credit' THEN amount ELSE 0 END) / NULLIF(SUM(CASE WHEN transaction_type = 'Debit' THEN amount ELSE 0 END), 0), ...