Emmie HannaSection HA1.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, contactnameFROM northwinds.customersWHERE country = ‘France”;CONTACTNAMECOMPANYNAMEMarie Bertrand
You've reached the end of your free preview.
Want to read both pages?
supply manager,Soy sauce,La maison d'Asie,Emmie Hanna