SELECT COUNT(*) FROM film JOIN film_category USING(film_id) JOIN category USING(category_id) WHERE category.name = 'Sci-Fi'
You should use the app on a larger display:
MySQL EXPLAINs include a lot of data that can not be simplified enough for a great experience on small mobile screens.