Using the JOIN operator: 1. Show each institution's name, with the religious affiliation for all religious institutions. (Show only the first 10 rows.)
2. Show each institution's name, with the religious affiliation, even if the college has no listed religious affiliation. (Show only the first 10 rows.)
3. Show each institution's name, along with the name of their region, for colleges located in large cities, along with their longitude and latitude coordinates. (Show only the first 10 rows.)
4. Show the top 20 institutions and the SAT averages, with the lowest admissions rates.
5. Show the top 20 institutions with the highest SAT averages.
6. Show a combination of both the highest SAT averages, and lowest admissions, using a UNION. (Show only 30 rows.)

7.23 main lab 7 - online shopping cart background this main lab extends the earlier prep lab "online shopping cart part 1". (you should save this as a separate project from the earlier prep lab). you will create an on-line shopping cart like you might use for your on-line purchases. the goal is to become comfortable with setting up classes and using objects. requirements this lab can be done individually or as pair programming. expanded itemtopurchase class (15 points) extend the itemtopurchase class as follows. we will not do unit testing in this lab so we will not be giving you the names of the member functions. create good ones on your own. create a parameterized constructor to assign item name, item description, item price, and item quantity (default values of "none" for name and description, and 0 for price and quantity). additional public member functions set an item description get an item description print the cost of an item - outputs the item name followed by the quantity, price, and subtotal (see example) print the description of an item - outputs the item name and description (see example) additional private data members a string for the description of the item. example output of the function which prints the cost of an item: bottled water 10 @ $1.50 = $15.00 example output of the function which prints the item description: