Advertisement
Guest User

Untitled

a guest
Nov 28th, 2015
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. SELECT x.Coffee, x.c
  2. FROM (
  3.     SELECT l.Coffee, COUNT(*) c
  4.     FROM likes l
  5.     WHERE l.Rating = 5
  6.     GROUP BY l.Customer
  7. ) x
  8. WHERE x.c = MAX(
  9.     SELECT COUNT(*)
  10.     FROM likes l
  11.     WHERE l.Rating = 5
  12.     GROUP BY l.Coffee
  13. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement