SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table groups (id_group int, name_group varchar(64)); create table users (id_user int, id_group int, user_name varchar(64)); select groups.id_group, groups.name_group, count(distinct users.id_user) size_group from groups join users on users.id_group = groups.id_group group by groups.id_group, groups.name_group having count(distinct users.id_user) between 1 and 5 ;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear