Pitanje 1.... » Tasks - Practice 05.txt
| 1 |
Task 1: |
|---|---|
| 2 |
Write a query that returns all the data about movies and adds information about the name of the director of each movie, as well as information on how many comments each movie has. |
| 3 |
|
| 4 |
Task 2: |
| 5 |
Create a view that provides insight into the data about all movies, with additional information on the name of the movie's director and information on how many comments each movie has. |
| 6 |
|
| 7 |
Task 3: |
| 8 |
Create a view that provides insight into all comments left by users for movies, and for each comment provide information about the name of the user who left that comment, the date and time of the last login of that user, as well as the name of the movie for which that comment was left. |