Recent content by ashill07

yes. will you join?

8.select c.first_name, c.last_name, ca.name as category, count(*) from rental r join customer c on c.customer_id = r.customer_id join inventory i on i.inventory_id=r.inventory_id join film f on f.film_id=i.film_id join film_category fc on fc.film_id=f.film_id join category ca on...

7.select c.first_name, c.last_name, count(*) from rental r join customer c on c.customer_id = r.customer_id group by r.customer_id, c.first_name, c.last_name order by count(*) desc limit 1;

6.select a.first_name, a.last_name, c.name from category as c join film_category as fc on c.category_id=fc.category_id join film as f on f.film_id=fc.film_id join language as l on l.language_id=f.language_id join film_actor as fa on fa.film_id=f.film_id join actor as a on a.actor_id=fa.actor_id...

5.select count(*) from category as c join film_category as fc on c.category_id=fc.category_id join film as f on f.film_id=fc.film_id join language as l on l.language_id=f.language_id where l.name='English' and c.name='Comedy';

4. select a.first_name, a.last_name, fa.actor_id, count(*) as film_number from film_actor fa join actor a on fa.actor_id=a.actor_id join film f on f.film_id=fa.film_id join language l on l.language_id=f.language_id where l.name='English' group by fa.actor_id, a.first_name, a.last_name having...

3.select count(*) from film f join language l on f.language_id=l.language_id where l.name='Japanese' limit 5;

2. select a.first_name, a.last_name, fa.actor_id, count(*) as film_number from film_actor fa join actor a on fa.actor_id=a.actor_id join film f on f.film_id=fa.film_id group by fa.actor_id, a.first_name, a.last_name, f.length having f.length>60 order by film_number desc limit 1;

1. select a.first_name, a.last_name, fa.actor_id, count(*) as film_number from film_actor fa join actor a on fa.actor_id=a.actor_id join film f on f.film_id=fa.film_id group by fa.actor_id, a.first_name, a.last_name order by film_number desc limit 1;

Inquiries: 1. Find the actor who has acted in the greatest number of movies. 2. Find an actor who has acted in the greatest number of films in excess of an hour. 3. Find the number of movies in Japanese. 4. Find all actors who have played in at least three Spanish-language movies. 5. Find the...

creating table are works insert table are works 3. and 4. questions i dont know how to do.

i dont know how to use. i am trying to learn.

I only dont understand how shows like that " BOOK - P. Beynon-Davies, Database Systems Warsaw, 2003. ISBN: 83-204-2726-6. Price: PLN 80, Scientific and Technical Publishers; - C. Paul, P. Pamela, Access 2000 PL, Krakow, 1999. ISBN: 83-7197-128-1. Price: PLN 59, Helion, additional CD-ROM; - A...

I fil all table