EJERCICIOS JOIN SQL

12. VARIAS TABLAS JOIN
select * from clientes as c join provincias as p on c.codigo=p.codigo;
select * from clientes as c.join provincias as p on codigo=p.codigo order by c.nombre;
12.1 VARIAS TABLAS LEFT JOIN
12.2 VARIAS TABLAS RIGHT JOIN
Tablas socios e inscritos
1. select * from socios as s left join inscritos as i on s.dni=i.dni
2. select * from inscritos as i right join socios as s on s.dni=i.dni;
4. select * from socios as s right join inscritos as i on s.dni=i.dni;
12.6 JOIN GROUP BY Y FUNCIONES DE AGRUPAMIENTO
Tabla clientes y provincias
1.select count (c.nombre), (p.nombre) from clientes as c join provincias as p on c.codigo group by p.nombre;
2.select count (c.nombre), p.nombre from clientes as c left join provincias as p on c. codigo group by p.nombre;;
3.select p.nombre count (c.codigoprovincia) as 'cantidad clientes' from provincias as p join clientes as c on p.codigo =c.codigo provincia group by p.nombre having count (c.codigoprovincia)>=2;
Tabla apartamentos y barrrios
2.select i.edificio, i.domicilio, i.piso, i.numeroapto, i.precio, b.nombre from inmuebles as i cross join barrios as b;
3.select i.edificio, count (i.domicilio), b.nombre from inmuebles as i join barrios as b on i.codigobarrio=b.codigo group by i.edificio;
4.selecti.domicilio, avg(i.precio) b.nombre from inmuebles as i cross join barrios as b on i.codigobarrio=b.codigo group by b.nombre;