A mini project of using WebSQL to working with fake e-commerce data on www.w3schools.com
Face e-commerce data tables consist of information related to customers, orders, shippers, suppliers, etc. on w3schools. Specifically, I used the "Suppliers" table, the "Products" table, the "OrderDetails" table, the "Customers" table, and the "Orders" table.
Where do the products US customers buy on this fake e-commerce platform come from? In other words, given the orders corresponds to customers in the USA, which country produces most products? Which country produces the least products? What's the ranking?