Prática - Exercícios Group By

praticagroupby.sql

--Q1:

SELECT COUNT("endDate") "currentExperience" FROM experiences;

--Q2:

SELECT "userId" id, COUNT(*) "educations" FROM educations GROUP BY "userId";

--Q3:

SELECT users.id, users.name writer, COUNT(*) "testimonialCount" FROM testimonials JOIN users ON testimonials."writerId" = users.id WHERE users.id = 435 GROUP BY users.id;

--Q4:

SELECT MAX(jobs.salary) "maximumSalary", roles.name role FROM jobs JOIN roles ON jobs."roleId" = roles.id WHERE jobs.active = true GROUP BY roles.name ORDER BY "maximumSalary";