Question

Consider the following MOVIE table and write the SQL query based on it.

MovieID	MovieName	Category	ReleaseDate	ProductionCost	BusinessCost
001	Hindi_Movie	Musical	2018-04-23	124500	130000
002	Tamil_Movie	Action	2016-05-17	112000	118000
003	English_Movie	Horror	2017-08-06	245000	360000
004	Bengali_Movie	Adventure	2017-01-04	72000	100000
005	Telugu_Movie	Action	-	100000	-
006	Punjabi_Movie	Comedy	-	30500	-

List the different categories of movies.

Answer 1

SELECT DISTINCT Category FROM MOVIE;

OR

SELECT DISTINCT(Category) FROM MOVIE;