clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1305687 fiddles created (20237 in the last week).

create table projects ( id int, responsable varchar(50), hours int); insert into projects values (1, 'Miguel',3), (2, 'Pedro',4), (3, 'Juan',1), (4, 'Miguel',1), (5, 'Laura',1), (6, 'Laura',3), (7, 'Laura',6), (8, 'Miguel',1), (9, 'Pedro',3); create table users ( id int, name varchar(50)); insert into users values (1, 'Laura'), (2, 'Pedro'), (3, 'Juan'), (4, 'Miguel'); SELECT users.name, SUM(projects.hours) horas FROM projects INNER JOIN users on users.name = projects.responsable group by users.name;
name horas
Miguel 5
Pedro 7
Juan 1
Laura 10
 hidden batch(es)