QUESTIONS:

1) Write a query to get productName and Quantity

2) Write a query to get First name and last name from employees.

3) Write a query to show company Name and Contact Name of customers where city is Buenos Aires

4) Find the name of the company that placed order 10290

5) Find the Companies that placed orders in 1997

6) Create a report showing employee orders.

Tutorial Question

1. Write a query to display the job title and average salary of employees.

2. Write a query to get unique department ID from employee table.

3. Write a query to find the name (first_name, last name), department ID and name of all the employees.