Question

uu Payments check Number paymentate amount customer Number Offices officeCode city phone addressLine1 addressLine2 state country postalCode territory officeLocation # Customers customer Number customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postalCode country sales RepEmployeeNumber creditimit customer Location Employees employeeNumber lastName firstName extension email reports To job Title officeCode E Product Lines productline textDescription Orders order Number order Date requiredDate shipped Date status comments customerNumber Order Details orderNumber product Code quantity Ordered priceEach orderline Number Products product Code productName productScale product Vendor product Description quantity in Stock buy Price MSRP productLine

Answer 1

5)

SELECT p.productName, c.customerName, e.firstName, e.lastName, o.orderNumber from Customers c, Employees e, Orders o, OrderDetails od, Products p where c.salesRepEmpoyeeNumber = e.employeeNumber and c.customerNumber = o.customerNumber and o.orderNumber = od.orderNumber and od.productCode = p.productCode order by e.lastName, e.firstName, c.customerName;

6)

select productCode, productName FROM Products where productCode not in (select productCode from OrderDetails od JOIN Orders o on od.orderNumber = o.orderNumber where  o.orderDate >= "2005-05-10") order by productName;