View the step-by-step solution to:

-#1 Find all films with maximum length and all other films) . -#1n other words let L be the maximum film rental duration in the table film. You...

This question was created from Assignment2-selection.sql. https://www.coursehero.com/file/20722654/Assignment2-selectionsql/

20722654-173908.jpeg

the output only gives one value of film_id 872 when the output was supposed to be film_id 2 6 9 17 21 23 25 26 37 46 48 50 60 65 69 71 82 90 101 109 111 114 120 124 126 129 135 137 141 142 148 156 169 175 182 184 185 189 195 205 210 212 214 216 225 233 237 243 247 257 260 269 275 285 292 295 304 306 308 314 321 324 327 344 345 349 350 363 364 366 374 382 386 389 402 409 414 415 426 429 431 434 438 444 448 453 460 461 464 472 480 482 483 484 488 496 499 501 503 517 519 529 531 536 537 542 547 548 551 558 567 574 575 579 580 582 583 589 590 599 606 609 618 619 624 625 643 650 651 652 653 656 659 662 667 669 673 674 678 690 692 698 704 713 715 720 723 728 730 738 746 750 753 763 764 768 771 774 778 791 796 799 816 817 819 820 836 846 848 851 853 857 859 861 865 872 873 876 878 879 889 891 892 895 896 897 901 904 908 909 910 912 913 916 917 919 920 925 932 936 938 946 953 966 973 977 978 984 987 990 991 1000 unsure why only one value prints and the correct answers are above?

20722654-173908.jpeg

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question