Hello, I am a total noobie at SQL and I still don't understand all the concepts. I want to see how to solve this first query and hopefully I'll be able to go from there. I have this database: Customer (CustNo, CustFirstName, CustLastName, CustStreet, CustCity, CustState, CustZip, CustBal) Employee (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEmail, SupEmpNo, EmpCommRate) Product (ProdNo, ProdName, ProdMfg, ProdQOH, ProdPrice, ProdNextShipDate) OrderTbl (OrdNo, OrdDate, CustNo, EmpNo, ShpName, ShpStreet, ShpCity, ShpState, ShpZip) OrdProd (OrdNo, ProdNo, Qty) 2 answers: first one using 3 simple subqueries nested, second one with JOIN (using no subqueries). List the product number, name, and price of those products with a price greater than $150 and were ordered in Jan 2008 by customers with balances greater than $400. Thank you in advance.