pe4 copy.txt - #Terence Budu-Biney#ISTE-230#Question#1...

This preview shows page 1 - 2 out of 2 pages.

#Terence Budu-Biney #ISTE-230 #09/19/2018 #Question #1 SELECT Title, Length FROM film WHERE description LIKE '%fun%' AND length <= 120; #Question #2 SELECT Title FROM film WHERE title LIKE '%a' OR title LIKE '%e' OR title LIKE '%u' OR title LIKE '%i' OR title LIKE '%o'; #Question #3 SELECT Title FROM film WHERE length >= 120 AND length <= 180; #Question #4 SELECT Title, Length FROM film WHERE title LIKE '%river%' AND rating IN('PG', 'PG-13'); #Question #5 SELECT Title FROM film WHERE release_year > 2012 AND length > 160; #Question #6 SELECT Title, replacement_cost AS 'Replacement Cost', Rating FROM film WHERE title NOT LIKE ('_a%') AND replacement_cost = 19.99;
Image of page 1

Subscribe to view the full document.

Image of page 2
You've reached the end of this preview.
  • Spring '19
  • Jane smith
  • Computer Programming, Set construction, #question, Terence Budu-Biney, #ISTE, #Terence

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern