SQL Aggregate functions and Joins
select count(*) from Customers; select avg(age) from Customers; select sum(age) from Customers; select min(age) from Customers; select max(age) from Customers; select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers inner join Orders on Customers.customer_id=Orders.customer_id; select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers left join Orders on Customers.customer_id=Orders.customer_id; select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers right join Orders on Customers.customer_id=Orders.customer_id; select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers full join Orders on Customers.customer_id=Orders.customer_id;