Question: 1. Write a query using the Suppliers and Products tables that will return the SupplierName and ProductName fields where the Suppliers table has related records

1. Write a query using the Suppliers and Products tables that will return the SupplierName and ProductName fields where the Suppliers table has related records in the Products table. Hint: Join the tables on the SupplierID field. 2. Write a query using the Suppliers and Products tables that will return the SupplierName and ProductName fields where the Suppliers table has related records in the Products table and the SupplierID is equal to 15. Hint: Join the tables on the SupplierID field. 3. Write a query using the Categories and Products tables that will return the CategoryName and ProductName fields where the Categories table has related records in the Products table. Sort the records by CategoryName and ProductName. Hint: Join the tables on the CategoryID field. 4. Write a query using the Categories and Products tables that will return the CategoryName and ProductName fields where the Categories table has related records in the Products table and the Price is greater than $40.00. Sort the records by CategoryName and ProductName. Hint: Join the tables on the CategoryID field. 5. Write a query using the Categories and Products tables that will return the CategoryName and ProductName fields where the Categories table has related records in the Products table and the value in the CategoryName field must start with the letter C and the rest of the characters can be anything. Sort the records by CategoryName and ProductName. Hint: Join the tables on the CategoryID field Use JOINS Please

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 General Management Questions!

Write a query using the Suppliers and Products tables that will return the SupplierName and ProductName fields where the Suppliers table has related records in the Products table. Hint: Join the...

Please help ASAP 2. Which of the following is the correct syntax for a value list? O'Option 15,"Option 2', 'Option 3 "Option 1";"Option 2":"Option 3" "Option 1":"Option 2":"Option 3" 21 3. To create...

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...

Could someone help me with this please. I dont know anything about it :( I suck at things like that. For maintaining its product and sales information Computer Wzadsloc contains the following three...

gfhfpostgreSQL - PART 1 : Creating a table using the following attributes: sale _ date,sale _ year,sale _ month,age,gender,country,state,category,sub _ category,quantity,unit _ cost , unit _...

postgreSQL - PART 1 : Creating a table using the following attributes: sale _ date,sale _ year,sale _ month,age,gender,country,state,category,sub _ category,quantity,unit _ cost , unit _...

Review Assignments Data File needed for the Review Assignments: Product.accdb The Product database contains data about Lakewood Community Health Services suppliers and their products, as well as data...

Exp19_Access_Ch02_Capstone - International Foodies 1.0 Project Description: International Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the...

Calculating by using queries 21? Updating records by using queries As you use a database and as it grows, you might discover that errors creep in or that some information becomes out of date. You can...

Quant ltd repurchase machinery at cost 3750000. The company expects, as a result, cash flow of 950000 , 1200000 and 1750000 over the next 3 years. What is payback period?

Cost allocation to divisions. Forber Bakery makes baked goods for grocery stores, and has three divisions: Bread, Cake, and Doughnuts. Each division is run and evaluated separately, but the main...

The Sierra Library District satisfies the criteria to be blended into the financial statements of Sierra County. Which of the following fund types of the two governments would not be combined in the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...