Lab 6.docx - Yiying Wang BUS 104 IA Lab 6 1 SELECT FROM northwinds Categories CATEGORYID CATEGORYNAME DESCRIPTION 1 Beverages

Lab 6.docx - Yiying Wang BUS 104 IA Lab 6 1 SELECT FROM...

This preview shows page 1 - 2 out of 2 pages.

Yiying WangBUS 104 IALab 610/10/20171. SELECT *FROM northwinds. CategoriesCATEGORYIDCATEGORYNAMEDESCRIPTION1BeveragesSoft drinks, coffees, teas, beer, and ale2CondimentsSweet and savory sauces, relishes, spreads, and seasonings3ConfectionsDesserts, candies, sweetbreads4Dairy ProductsCheeses5Grains/CerealsBreads, crackers, pasta, and cereal6Meat/PoultryPrepared meats7ProduceDried fruit and bean curd8SeafoodSeaweed and fish2. SELECT companyname, contactnameFROM northwinds.customersWHERE country = 'France'COMPANYNAMECONTACTNAMEParis specialitesMarie Bertrand
Background image
Background image

You've reached the end of your free preview.

Want to read both pages?

  • Spring '17
  • Robert Morris
  • Business

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture