Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT s.name, s.gunSize
- FROM Ships s
- WHERE gunSize = (SELECT max(gunSize)
- FROM Ships s2
- WHERE gunSize < (SELECT MAX(gunSIZE) FROM Ships))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement