Assignment 4 on SQL Chapter 4 Student Name: _____________________ Due Date: _________________________ Instructor Remarks: Use aliases if possible Use order by if possible We are covering the equijoin only, which is the join mentioned in the slides. So no other joins are accepted. Not the outer join, or inner join, or.... If the question asks to display some attributes from different tables then all the tables that include those attributes should be listed in the "FROM" clause. If the attributes displayed come from different tables that are not directly connected, then you have to involve other tables that directly connect the different tables in the "From" clause. Every time you have more than one table in the "From" clause, you must join them using PK = FK. Please refer to the examples in the slides. Any condition on a group, like an aggregate, the condition goes in the "Having" clause For all the questions below, please submit the SQL script along with the results. Use the database that you have created in previous weeks 1. Display a list of invoice number, invoice customer code, customer last name, and customer first name. 2. Display a list of invoice date, product code, product description, lint units, and line price. 3. Generate a list of product description, product price, vendor name, vendor contact, vendor area code, and vendor phone number for products with the invoice date after 17-Jan-2012 4. Find the number of customers in each area code (Use Group by) 5. List the number of products in the inventory supplied by each vendor. Limit the list to products whose price average less than $10. (Use Group by and Having)