Facebook

Untitled safest cryptocurrency exchange

From Dominik Zalewski, 4 Years ago, written in PostgreSQL.
URL https://pastebin.pl/view/dc03f68a
Embed
Download Paste or View Raw
Hits: 203
  1. SELECT first_name, last_name,
  2. COUNT(*) as film_count
  3. FROM    actor
  4. JOIN film_actor on
  5. film_actor.actor_id = actor.actor_id
  6. JOIN film on film_actor.film_id = film.film_id
  7. WHERE length > 90
  8. GROUP BY first_name, last_name
  9.  
  10.  
  11. SELECT
  12. CONCAT(first_name, '' , last_name) as actor
  13. , COUNT(f.title) as number_of_Films
  14. FROM actor
  15. join film_actor AS fa on actor.actor_id = fa.actor_id
  16. join film AS f on f.film_id = fa.film_id
  17. GROUP BY
  18. actor
  19. ORDER BY Number_of_films DESC
  20.  
  21. SELECT selected_actors.first_name, selected_actors.last_name, SUM (payment,amount) as Zarobki
  22. FROM(
  23. SELECT first_name,last_name, actor.actor_id, COUNT (8) as film_count
  24. FROM actor
  25. JOIN film_actor on film_actor.actor_id = actor.actor_id
  26. JOIN film on film_actor.film_id =film.film_id
  27. WHERE length >90
  28. GROUP BY first_name.last_name

Reply to "Untitled"