EG: SELECT *
FROM Movies;
HERE IS THE QUESTIONS v .
- Write The Sql Statement For The Following Question Eg Select From Movies Here Is The Questions V 1 (171.19 KiB) Viewed 30 times
WRITE THE SQL STATEMENT FOR THE FOLLOWING QUESTION. EG: SELECT * FROM Movies; HERE IS THE QUESTIONS v .
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
WRITE THE SQL STATEMENT FOR THE FOLLOWING QUESTION. EG: SELECT * FROM Movies; HERE IS THE QUESTIONS v .
WRITE THE SQL STATEMENT FOR THE FOLLOWING QUESTION.
EG: SELECT *
FROM Movies;
HERE IS THE QUESTIONS v .
23 VideoStore database contains the following seven relations as shown in Figure Q3. Movies (MovicNum, Title, YearReleased) Stars (StarId, GivenName, FamilyName) Actsin (Sla1 Id, MovieNuin) Copies (BarCode, MovieNum, Iormat, RentalCiode) RentalRates (RontalCode, Rentalresiod, Rate) Customers (CustNum, FName, LName, Ad Rentals (CustNum. BüCode. Pulel)ue, L)ate Figure Q3 (a) List all the details (i.e. all columns) of Parit Raja customers who do not lave a lowe ploue number. Note that "Parit Raja" may oocur anywhere in their addesk, tather thait just at the rud (3 marks) (b) List the year-released and title (only) of each movie that was released after the end of 2015 but before the end of 2019. List this information in ascending order of year-released, and then by alphabetical order of title whenever the year-released is the same. (3 marks) (c) List the number copies of movies that are recorded in the database, include the oldest YearReleased, the most recent YearReleased and the distinct different YearReleased values are there in the database. (4 marks) (d) List the titles and year released of all movies that Brad Pitt is in. (5 marks) (e) What are the given and family names of stars who are in four or more movies, and how many movies are they in? (5 marks)
EG: SELECT *
FROM Movies;
HERE IS THE QUESTIONS v .
23 VideoStore database contains the following seven relations as shown in Figure Q3. Movies (MovicNum, Title, YearReleased) Stars (StarId, GivenName, FamilyName) Actsin (Sla1 Id, MovieNuin) Copies (BarCode, MovieNum, Iormat, RentalCiode) RentalRates (RontalCode, Rentalresiod, Rate) Customers (CustNum, FName, LName, Ad Rentals (CustNum. BüCode. Pulel)ue, L)ate Figure Q3 (a) List all the details (i.e. all columns) of Parit Raja customers who do not lave a lowe ploue number. Note that "Parit Raja" may oocur anywhere in their addesk, tather thait just at the rud (3 marks) (b) List the year-released and title (only) of each movie that was released after the end of 2015 but before the end of 2019. List this information in ascending order of year-released, and then by alphabetical order of title whenever the year-released is the same. (3 marks) (c) List the number copies of movies that are recorded in the database, include the oldest YearReleased, the most recent YearReleased and the distinct different YearReleased values are there in the database. (4 marks) (d) List the titles and year released of all movies that Brad Pitt is in. (5 marks) (e) What are the given and family names of stars who are in four or more movies, and how many movies are they in? (5 marks)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!