ITM 500 Lecture Notes - Lecture 5: Banana, Hard Coding, Aggregate Function

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Raymond Moss

Document Summary

Note: while it is understood that groups may share their expertise and communicate with each other, each group"s work must reflect sufficient individual group effort to merit its grade. Providing solutions to other groups is not acceptable. Such blatant collusion will result in a grade reduction and in extreme cases could result in a zero and a charge of academic misconduct. Using the project1f18 database, populate the database with sufficient data to test your queries (see note below). Develop and document the sql queries necessary to satisfy the following. Only show in the output the details required by the specifics of the query. List the details for all c type orders for the customer named "charlie" that contained sales for the item "apples". List the order no. for orders that have been placed in 2014 containing more than 3 sale item entries. List the customers" details for customers who have placed orders items in the "fruit" (fr) or.