query assignmennt2

select count(*) from film_list join film on film_list.FID=film.film_id where special_features like '%Deleted Scenes%' and category='Documentary';
select count(*) from inventory join rental on inventory.inventory_id=rental.inventory_id where film_id in(select FID from film_list where category='Sci-Fi') and (staff_id,store_id)=(select ID,SID from staff_list where name='Jon Stephens');
select total_sales from sales_by_film_category where category = "ANIMATION";
select category.category_id,category.name,count(*)as count_freq from (select rental_id,inventory_id from rental join customer_list on  rental.customer_id=customer_list.id where name='PATRICIA JOHNSON')as rental_inventory join (select inventory_id,category_id from inventory join film_category on inventory.film_id=film_category.film_id)as invent_catg on rental_inventory.inventory_id=invent_catg.inventory_id  join category on invent_catg.category_id=category.category_id group by category_id order by count_freq desc limit 3;
select count(*)as count_freq from (select rental_id,inventory_id from rental join customer_list on  rental.customer_id=customer_list.id where name='SUSAN WILSON')as rental_inventory join (select inventory_id,inventory.film_id,rating from inventory join film on inventory.film_id=film.film_id)as invent_film on rental_inventory.inventory_id=invent_film.inventory_id where rating='R';