SQL Assignment

Using the MySQL SQL interface, answer the following queries. Put your name in the file within a comment. For each query, include a comment that states the query. All columns must have reasonable names.

1. Find the userid, shares, price and amount spent for all transactions totalling over $100,000.
2. For all purchases in March, 2003, find the userid, the cost, and the commission (1% of the cost)
3. For all purchases in March, 2003, find the userid, the cost, and the commission, where the commission is 1% for purchases of 500 or more shares, and 2% otherwise
4. Output all the states with more than 10 customers
5. Find the lowest low and the highest high price in stockprices.
6. Find the average cost of purchases in March, 2003
7. Find the total number of shares bought by customers in 2003
8. For each year, find the total change in stock holdings for each customer, assuming the customer has more than 1 transaction. Output the userid as well as the year.

Write a JDBC program to answer the last query. You may only send one query to the database, and it is:

select * from stockorders;

Make sure your answer is the same as with the database query.