1) Construct and Run each SQL in Access or Base,

2) Review results for correctness - do NOT submit results,

3) Copy and Paste tested SQL statement to the answer window of each query.

What is the average price of all tasks with a description containing the word 'networking'?

List order number, order date, client number, client name, and city of each order placed by clients from 'Easton' or 'Tri City.'

List order number, order date, client name, and city of every order from clients with a name containing the word 'Shop' or 'Sales.'

List order number, order date, client number, task ID and quoted price for each task in all orders placed by client number '826' or '867.'

List client name, city, and consultant last name of all clients with a balance greater than the maximum balance of all clients from city 'Harpersburg.'

List task ID, description, and price of all tasks with a price greater than that of a task with task ID 'DA11.'

List client name, credit limit, consultant number, and consultant last name of every client who has a higher credit limit than that of a client named 'MarketPoint Sales.'

List consultant last name, count of clients, and average balance of all clients for each consultant.

List order number, task ID, quoted price, and task price of each order line where quoted price is NOT equal to task price. Hint: task price in Tasks, quoted price in OrderLine.

List order number, order date, client name, and client city of all orders placed NOT on the same date as order number '67838.'