INFO6090 Business Intelligence

1. Query:
SELECT * FROM Customer_t WHERE Customer_State LIKE 'NJ';
11 American Euro Lifestyles 2424 Missouri Ave N.Prospect Park NJ 075085621
4 Eastern Furniture 1925 Beltline Rd. Carteret NJ 070083188
2. Query:
SELECT Customer_Name FROM Customer_t WHERE Customer_Id in (SELECT
Customer_Id from Order_t where Order_Id=1008);
Battle Creek Furniture
3. Query:
SELECT * FROM Product_t WHERE Product_Id IN (SELECT Product_Id FROM
Order_Line_t WHERE Order_Id = 1006);
7 Dining Table Natural Ash 800.0000 2
4 Entertainment Center Natural Maple 650.0000 3
5Writers Desk Cherry 325.0000 1
4. Query:
SELECT * FROM Product_t WHERE PRODUCT_Finish LIKE 'Natural Ash';
3 Computer Desk Natural Ash 375.0000 2
7 Dining Table Natural Ash 800.0000 2
2 Coffe Table Natural Ash 200.0000 2