Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function AVG
Functions SUM, MAX, MIN
Review
33. Exercise 1

Instruction

Let's start easy.

Exercise

Count the number of all projects, the number of clients that have commissioned at least one project (that is, count them once even if they commissioned more than one project) and the average price for all the projects. Name the columns: projects_no, clients_no, and average_price.