Copy your SQL query from W3 Schools website and paste the SQL query directly beneath each question. There is no need to paste the output from the query into this file.

1. Write an SQL query that selects the Customer Name and Contact Name from the Customers table.

2. Write an SQL query that selects all the records from the Categories table.

3. Write an SQL query that selects the Supplier Name , Contact Name, and City from the Suppliers table where the City equals Boston.

4. Write an SQL query that selects the Supplier Name and City from the Suppliers table where the City is not equal to Boston.

5. Write an SQL query that selects the Product Name, Price and Unit from Products where the Price is greater than or equal to 20.

6. Write an SQL query that selects the Customer Name and Country from the Customers table where the Country is equal to Canada.

7. Write an SQL query that selects the Order ID, Employee ID and Shipper ID from the Orders table where the Shipper ID is 3 or the Employee ID is 5.

8. Write an SQL query that selects the Product Name, Category ID and Price from the Products table where the Category ID is 2 and the Price is less than 30.

9. Write an SQL query that selects the Product Name, Unit, and Supplier ID from Products table and order the output by Product Name and then by Supplier ID.

10. Write an SQL query that selects the Product Name, Price, Supplier Name from the Products table and the Suppliers table where the Supplier ID on Products is equal to Supplier ID on Suppliers and the Price is greater than 20.