|Select all the products supplied by Leka Trading|
|Select all the orders raised by a customer called "Island Trading"|
|Select all the products supplied by UK based suppliers|
|Show all the products supplied by suppliers based in North America (USA or Canada)|
|Show all the products ordered by a customer called "Island Trading"|
|Use a query to find a list of shipping companies which have already been used to ship orders to customers based in Argentina.|
|List the company name, firstname and lastname of contact for the customers who have had an order managed by the employee Robert King. Sort this list of customers by contact.|
Explain why it would have been a better idea to use two fields, contactFirstname and contatLastname to store the name of the contact in the customers table.