The purpose of this set of web pages is to demonstrate knowledge of building Microsoft Excel based solutions, data structure design and live querying on data tables (MySQL and MS SQL).
This page is an interactive demonstration of a set of live SQL queries.
Please select a customer's name from the dropdown list at the foot of the page and click the 'Submit' button.
The resultant output demonstrates that the data is being extracted from the database and is not a set of pre-written HTML tables.
Customers listed are those that have placed orders in 2017