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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!