Which type of join is used to show all the entries in the table containing the primary key regardless of whether that
ID has an entry in the second table?
left outer join
right outer join. inner join
self join

Ido not understand this project overview agricultural commodities are bought and sold through the stock exchange. the price of commodities changes all the time. investors buy many agricultural commodities before they are ready for shipping. when an investor buys an agricultural commodity that is going to be ready in the future, they call this purchasing futures. this might be a future crop, meat that has not yet been processed, or another type of agricultural commodity. for this project, you will have to decide how to spend $10,000. research the new york stock exchange. find one or more agricultural commodities that you are interested in. remember, it may be listed as a future crop. instructions identify the agricultural commodities that you think have the best chance of going up in price. think about what is going on with supply and demand. decide how you will spend your money. you may purchase only agricultural commodities. check the market every day for a week. record the price of your commodity or commodities each day. you may buy or sell your commodities at any time during the week. you may sell your commodities and buy different ones. feel free to experiment with the $10,000 by buying and selling commodities, but make sure to keep a careful record of your activities. at the end of the week, you will write a report on your investments. this report should be structured to include this information: page 1: explain how the stock market works. page 2: list all commodities purchased. describe each in detail. discuss why you selected these commodities. remember, they must be agricultural. page 3: create a chart or graph to illustrate the price of your commodity or commodities over the week’s time. list all of your activity buying and selling. make sure you include prices and details. page 4: write a summary of your experience. describe what you might do differently if you were using actual money. propose potential reasons why the price of each commodity may go up or down.