Science fiction is usually differentiated between hard sci-fi and space opera. The line is blurry. Hard sci-fi is, or tries to be, rooted in actual science. The science can be speculative (eg FTL travel, FTL communication, wormholes) that really have no basis in any actual theory but these still count as "science". The focus of the work is to explore the implications of some technology or science.
Space opera, on the other hand, doesn't focus on the science (speculative or otherwise). It's just "there". The focus is more on traditional melodramatic elements of narrative.
Hard sci-fi examples: pretty much anything by Larry Niven, Archur C. Clarke or Alastair Reynolds.
Space opera: Star Trek, Star Wars.
I see science fantasy as the mixing of sci-fi and traditional fantasy elements (eg wizards in spaceships) or where technology takes on the appearance of fantasy elements (eg mental powers that are essentially "magic").