INFO6090 Business Intelligence

Added on - 09 Sep 2021

  • INFO6090


  • 2


  • 169


  • 9


  • 0


Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
1. Query:
SELECT * FROM Customer_t WHERE Customer_State LIKE 'NJ';
11American Euro Lifestyles2424 Missouri Ave N.Prospect ParkNJ075085621
4Eastern Furniture1925 Beltline Rd.CarteretNJ070083188
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);
7Dining TableNatural Ash800.00002
4Entertainment CenterNatural Maple650.00003
5Writers DeskCherry325.00001
4. Query:
SELECT * FROM Product_t WHERE PRODUCT_Finish LIKE 'Natural Ash';
3Computer DeskNatural Ash375.00002
7Dining TableNatural Ash800.00002
2Coffe TableNatural Ash200.00002
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document