Sample Data
movie-data

  Problem Statements

1. Find out the list of movies based on genre type.

2. Find out the list of movies which are having same rating and short data in ascending order based on rating values.

3. Show filtered data based on condition for specific column.


  Spark SQL Query Solutions

Query 1.   SELECT genre, count(*) FROM Movie GROUP BY genre;


Query 2.   SELECT rating, count(*) FROM Movie GROUP BY rating ORDER BY rating;


Query 3.   SELECT * FROM Movie WHERE  ;



Note: 'WHERE' condition in Query 3 can be edited ... such as ( genre='Action' or summary like '%love%' or budget > 250000000 )