Structured Query Language - SQL

lab notes

Exercise 1 Do the following exercises using the schema from exercise 5.2 

• Find the total number of parts supplied by each supplier.
• Find the total number of parts supplied by each supplier who supplies at least 3 parts.

(5.2 questions 10 and 11)

• For every supplier that supplies only green parts, print the name of the supplier and the total number of parts that he supplies. 
• For every supplier that supplies green part and red part, print the name and the price of the most expensive part that he supplies. 

Exercise 2

• Download the example from here - EmbeddedSQL.java
• You also will need this file pg73jdbc3.jar
• Following the instructions here compile and execute the example
• Implement functions Query2 and Query3 in the example