Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT x.Coffee, x.c
- FROM (
- SELECT l.Coffee, COUNT(*) c
- FROM likes l
- WHERE l.Rating = 5
- GROUP BY l.Customer
- ) x
- WHERE x.c = MAX(
- SELECT COUNT(*)
- FROM likes l
- WHERE l.Rating = 5
- GROUP BY l.Coffee
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement