1. List ProductName, SupplierID, CategoryID and Price for all Products where Price is in between 10 and 20.
2. List all Customers who live in 'Paris' or 'London'.
a) First write the query using the 'OR' operator
b) After this, write the same query but now use the 'IN' operator to replace 'OR'
3. List CustomerID, CompanyName, City, Country for Customers who live in the 'USA' and who live either in the City of 'Portland' or 'Anchorage'.
4. List the EmployeeID, and Employee Name (formatted as FirstName + ' ' + LastName) for Employees.
5. List the CustomerID and Company Name, FaxNumber for Customers who have a Fax number.
6. List the CustomerID and Company Name, FaxNumber for Customers who don't have a Fax number.
7. List all Customers ordered by Country
8. List all the distinct CategoryID from the Products table.
9. List the top 1 Product from the Products table.
10. List the top 1 product which has the lowest Price.