Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Arrow charts and slope charts are alternatives to multiple pie charts when the data consist of the values or the percentage breakdown of several categories for two time periods.