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

Ask a homework question - tutors are online