The Super Game Boy is a peripheral for SNES, not a game. It plays Game Boy cartridges on SNES with enhancements (color palettes, borders, effects).
It does not enable multiplayer. It enhances single-player Game Boy games only. For SNES multiplayer, use games designed for it with appropriate controllers/multitap.