#1In the Analysis database, write 2 queries that join the zipcensus table with the zipcounty table based on their appropriate keys. In the first query use an inner join and in the second query use a full outer join. In addition to providing the queries, provide a screen shot in a word document of the Execution Plan of the query that has the lower overall Estimated Subtree Cost of the two.

#2 In the Analysis database provide a list of customer first names, the zip code of their order, and the state of their order using the customers and orders tables. Also include an additional column for the population (totpop) of the zip code that their order was placed in from the zipcensus table. If there is not a population value for that zipcode (aka null) then use a case statement to return 0 instead. -- Limit the results only to orders from Montana .

#3 In the Analysis database, write an SQL Query to return a count of products for each group name that are in stock and a count for those that are out of stock using a single query.