daily pastebin goal
0%
SHARE
TWEET

Untitled

a guest Feb 17th, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /***************************/
  2. /* Name: Tiffany Nguyen */
  3. /* Class: CS3410 */
  4. /* Term: Spring 2019 */
  5. /* Lab #: 3 part2 */
  6. /***************************/
  7.  
  8. /* List the name of all products for which an order was placed. */
  9.  
  10.  
  11. /* List the name of customers that ordered product ‘p07’ */
  12.  
  13.  
  14. /* List name of agentsthat placed an order for customer c003 or customer c006 */
  15.  
  16.  
  17. /* List name of customer sthat ordered product ‘p01’ through agent 'a01' */
  18.  
  19.  
  20. /* List the name of each customer that placed an order, the pid of what they ordered. */
  21.  
  22.  
  23. /* List the name of each customer that placed an order and the product name for each product they ordered. */
  24.  
  25.  
  26. /* List the name of each customer and the total amount ordered by the customer. */
  27.  
  28.  
  29. /* List the name and the sum of dollars for each customer that ordered more than $1,000 */
  30.  
  31.  
  32. /* List the agent name, product name and customer name for each product ordered. */
  33.  
  34.  
  35. /* What would be the result of the following SQLStatement: SELECT * from CUSTOMERS, PRODUCTS */
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top