Search results

  1. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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...
  2. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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;
  3. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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...
  4. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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';
  5. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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...
  6. ashill07

    Lets Play coding database. I can see so many forums people are doing.

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

    Lets Play coding database. I can see so many forums people are doing.

    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;
  8. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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;
  9. ashill07

    Lets Play coding database. I can see so many forums people are doing.

    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...
  10. ashill07

    I need help. I am trying to learn SQL

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

    I need help. I am trying to learn SQL

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

    I need help. I am trying to learn SQL

    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...
  13. ashill07

    I need help. I am trying to learn SQL

    I fil all table
  14. ashill07

    I need help. I am trying to learn SQL

    But this not homework. I am not studying. I am 38 years old. i find it i try to do but i have always error. Create table Authors ( AuthorID int identity(1,1) primary key, Title varchar(10), Name_Surname varchar(50) not null, Birth_day date, Salary decimal null ) Create Table Books ( BookID...
  15. ashill07

    I need help. I am trying to learn SQL

    1. Create a project of a database for authors and books. Determine the necessary tables and their structure in the database. 2. The designed one should enable the following data to be recorded: AUTHORS - prof. Paul Beynon-Davies, b. 1964-03-23. Fees: PLN 6,000; -prof. Andrzej Stachurski, b...
Top Bottom