fork download
copy 
  1. SELECT * 
  2. FROM mitarbeiter m 
  3. join 
  4. 	(SELECT mnr as x, count(thema) as ANZAHL FROM 
  5. 		(SELECT k.mnr, b.thema FROM
  6.  		kundenbetreuer k right
  7.  		join betreut b on 
  8.         	(k.mnr = b.betreuer) 
  9. 		GROUP BY k.mnr, b.thema) 
  10. 	GROUP BY mnr HAVING anzahl = 
  11. (SELECT max(t) FROM (SELECT count(thema) as t from betreut group by betreuer, thema)) 
  12. on (m.mnr = x)
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/8Be31
language:
SQLite (sqlite 3.27.2)
created:
14 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!