Question: Please run the SQL Tryit Editor v1.6 (w3schools.com) (Links to an external site.) in your web browser. Use this free web-based software to experiment with

Please run the SQL Tryit Editor v1.6 (w3schools.com) (Links to an external site.) in your web browser. Use this free web-based software to experiment with writing the queries for this assignment. You can enter your SQL queries, following the 'select ..... from ..... where .....' pattern. To execute the query, click on the green Run SQL button. You will see the results of your query below. The database is already populated with the tables that are listed on the right of the screen (under 'Your Database'); these tables already contain data that you can query.

Please write and execute the following three queries. When each query result is visible in the browser, please cut and paste each correct SQL query into a word document (you do not need to paste the result output into the Word document):

  1. Find the Supplier ID numbers and the Supplier names of all suppliers (query the Suppliers table) - this query returns 29 rows with 2 columns
  2. Find the names of all the Customers from the USA (query the Customers table) - this query returns 13 rows with 1 column
  3. Find the names of all products that Tokyo Trader supplies (join the Suppliers and Products tables for your query) - this query returns 3 rows with 1 column

Please cut and paste the three SQL-queries from your Word document into the answer textbox of this assignment in WebCampus and submit it.

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!