Curso Postgresql Análisis de Datos y Business Intelligence

Recursos Curso Postgresql – Análisis de Datos y Business Intelligence en Udemy

Ejercicios Análisis de Datos

Actualizamos el Curso y recursos mientras tengamos mas estudiantes, pueden dejar sus dudas por acá, para estudiantes inscritos nada mas

select id, sum(id) as total_categorys
from maincategorys
group by id;

select count(id) as total_categorys
from maincategorys;

select * from maincategorys;

select * from subcategorys;

select subcategory_name
from maincategorys
inner join subcategorys
on maincategorys.subcategory_id = subcategorys.id;

select subcategory_name
from maincategorys as a
inner join subcategorys as b
on a.subcategory_id = b.id;

select b.subcategory_name, count(a.id)
from maincategorys as a
inner join subcategorys as b
on a.subcategory_id = b.id
group by b.subcategory_name;

select b.id ,b.subcategory_name, count(a.id)
from maincategorys as a
inner join subcategorys as b
on a.subcategory_id = b.id
where b.id = 2
group by b.subcategory_name,b.id
order by b.id asc;

\d+ posts;

select * from posts;

select count(posts.views) as total_posts from posts;

select posts.post_name,posts.views, count(posts.views) as total_posts
from posts
where posts.views
between 10 and 2000
group by posts.post_name,posts.views
order by posts.views asc;

select posts.post_name,posts.views, count(posts.views) as total_posts
from posts
where posts.views
between 2023-01-19  and 2023-01-19 
group by posts.post_name,posts.views
order by posts.views asc;