$5.$ Create a column called Region for suppliers in your table, and classify suppliers into three regions: North America, Asia & Europe.

$6.$ What is the number of factories we have in each region?

$7.$ How many factories do we have per region that have a CPC and GCC certification?

JOINS $+$ SUBQUERIES

$8.$ Create a column that labels suppliers as domestic $($including NAFTA countries$)$ and international.

$9.$ How much did we buy domestically vs internationally?

$10($Hard $/$ Not Covered in Class... give it your best shot!$)$: What percentage did we buy domestically of all the goods we purchased? HINT: Take how much we bought domestically and divide it by the total cost overall.