SQL_Q

SQL_Q - 7 Display average maximum minimum prices from...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Write a SQL statement to: 1. Display all rows in the CUSTOMER table 2. Display all rows in the VENDOR table 3. Display all rows in the PRODUCT table 4. Display customer names that have more than $500 in their balances. 5. Display the number of product in PRODUCT table 6. Display the list of products that are distinct in PRODCUT table.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 7. Display average, maximum, minimum prices from PRODUCT table. 8. Display the customer names, customer_phones of customers that have $0 balance. 9. Display all the rows from Vendor that have “Smith” as a contact....
View Full Document

This note was uploaded on 02/28/2012 for the course IS 410 taught by Professor Chen,z during the Fall '08 term at UMBC.

Ask a homework question - tutors are online