SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create Table person ( id integer, name text, section text, PRIMARY KEY (id) ); create Table fruit ( id integer, name text, personid integer, PRIMARY KEY (id), FOREIGN KEY (personid) REFERENCES person(id)); insert into person values (1, 'ВАНЯ', '1 отдел'), (2, 'Петя', '2 отдел'), (3, 'Коля', '3 отдел'); Select * from person; insert into fruit values (1, 'БАНАН', 1), (2, 'БАНАН', 1), (3, 'ЯБЛОКО', 2); Select * from fruit; select person.section, count(person.id) from person JOIN fruit ON person.id=fruit.personid GROUP BY person.section;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear