DML exercises

.docx

School

Towson University *

*We aren’t endorsed by this school

Course

315

Subject

Information Systems

Date

Apr 29, 2024

Type

docx

Pages

16

Uploaded by ojomark025 on coursehero.com

jDML exercises You will use video store tables and data for this lab. Please insert your SQL statement and add a result table/output as a screenshot. 1. List films that is horror or action SELECT * from film where type= 'HORROR' or type= 'ACTION'; emmanuel SELECT FNAME, TYPE FROM FILM WHERE TYPE='HORROR' OR TYPE='ACTION'; Dominic (Samuel Alao) (Samuel Alao select * from film where TYPE = 'HORROR' OR TYPE = 'ACTION' —-Sara Habtemariam
SELECT * from film where type= 'HORROR' or type= 'ACTION'-Damilola Adegbuyi
Dada Opeyemi 2. List customers who live in London -Kenneth Mortiniera select CNAME from customer where city = 'London' - Mark Ojo -Mark Ojo 3. List movies that were rented after 11-01-2014
(Andy Bempah) 4. List films that is horror and price is greater than $5 select fname from film where price > 5 OR type = 'HORROR'; marvin lopez select type, price from film where type='HORROR' and price >5 - Mark Ojo -Mark Ojo 5. Update the price of all action movies to $10.00 Update film SET price = 10 where TYPE = 'ACTION'(Chris R) (UPDATE film SET price = 10 WHERE type = 'ACTION';
)(Yashu G) 1. List the total number of movies rented by customers 2. List the number of customers per each movie
3. List the movie that is most expensive. (christian B will do this)(look on next page if the display breaks into two pages. There are two screenshots of my sql display) SELECT FNAME FROM FILM WHERE PRICE = (SELECT MAX(PRICE) FROM FILM); 4. List FID that is rented more than 3 times
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help