Lab 6-hannaem .docx - Emmie Hanna Section HA 1 The Supply manager wants a list of all information about all product categories SELECT FROM

Lab 6-hannaem .docx - Emmie Hanna Section HA 1 The Supply...

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

Emmie Hanna Section HA 1.The Supply manager wants a list of all information about all product categories. SELECT *FROM northwinds.categories;CATEGORYIDCATEGORYNAMEDESCRIPTION1BeveragesSoft 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.The Sales manager wants to know names and companies of all of the customers North winds has in France. SELECT companynaem, contactname FROM northwinds.customers WHERE country = ‘France”; CONTACTNAME COMPANYNAME Marie Bertrand
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '19
  • supply manager, Soy sauce, La maison d'Asie, Emmie Hanna

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture