Question: Write and execute SQL for the following. Use the Northwind sample database. Include the SQL for each problem in your results submitted to your instructor.

Write and execute SQL for the following. Use the Northwind sample database. Include the SQL for each problem in your results submitted to your instructor. Do NOT use the MS Access Query By Example (QBE) feature. Actually write the SQL 1. Create a query that will 'join' the Products, Categories, and Suppliers tables, and produce a result set with the following columns: CategoryName Country from the Products Table from the Categories Table from the Suppliers Table Only include Products from Suppliers in Germany and France. Create a query that will join, the Products, Categories, and Suppliers tables, and produce 2. a result set with the following columns: from the Products Table from the Products Table from the Categories Table from the Suppliers Table ProductID ProductName CategoryID SupplierID Only include Product names that start with the letter 'G Create a query that will 'join' the Products, Categories, and Suppliers tables, and produce 3. a result set with the following c ProductID olumns: CategoryID Country from the Products Table from the Categories Table from the Suppliers Table Only include Products from Suppliers in London. 4. Create a query that will 'join' the Products, Categories, and Suppliers tables, and produce a result set with the following columns: CategoryID Country from the Products Table from the Categories Table from the Suppliers Table Only include Products from Suppliers whose Company Name Begins with the letter 'L
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
