For the questions below, use the W3Schools customer orders database. You need to

Question

For the questions below, use the W3Schools customer orders database. You need to submit thoroughly tested SQL statements. For your convenience and reference, relevant data model is attached as a PDF document with the assignment in the Blackboard. Name of this document is "RelationshipDiagramW3schoolsorder.pdf" 1) List the country wise customer count. Your query should show name of the country and number of customers in that country 2) ist all the names of the products supplied by suppliers located in Japan. 3) List the number of products in each category. Your query should display the name of category and number products in that category 4) List order ID, Order Date for all the orders from year 1996. W3SCHOOLS SQL is located at http://www.w3schools.com/sql/default.asp (Preferred browser is Chrome). On this page you will find a button called "Try it yourself". Click on that button. You will be redirected to a page where you see a list of tables on the right side of the page. It is highly recommended to click 'Restore Database' button on this page during every session. The page contains a box where you can type in an SQL statement involving the listed tables. You type in your SQL statement in that box and click on "Run SQL" button. The results will be displayed if your SaL statement is syntactically correct

Explanation / Answer

1) select count(customerName),country from customers group by country;

2)select a.productname   from products a ,suppliers b    where a.supplierid = b.supplierid and b.country="japan";

3)select a.categoryname,count(b.productname) from categories a , products b where a.categoryid=b.categoryid

group by a.categoryname;

4) select * from orders where orderdate > '1995-31-12' ;

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.