a) Select the total rental_rate for films grouped by their categories. Order the result from largest to smallest. b) Select all actors who acted together with JOE in any film. Use inner query. c) Create a view, which has category names and number of films each category has. Film Film Actor SMALLINT SMALLINT PF actor_id PF timid Pim id Language Planguage id SMALLINT name CHAR (20) title description release year Flanguage_id F original language_id rental duration rental rate SMALLINT VARCHAR2(255) VARCHAR2 (255) SMALLINT SMALLINT SMALLINT SMALLINT NUMBER (42) SMALLINT NUMBER (5.2) VARCHAR2 (6) VARCHAR2 (255) TIMESTAMP length replacement_cost rating special features last update Film Category PF im id SMALLINT SPF category.id SMALLINT Actor P. actorid SMALLINT first name VARCHAR2 (45) last name VARCHAR2 (45) Fnationality CHAR (2) Country P country.id SMALLINT U short code CHAR(2) name VARCHAR2 (25) Category P. Category SMALLINT "name VARCHAR2 (25) parent.cat SMALLINT