Questions tagged [movies]
The movies tag has no usage guidance.
17
questions
0
votes
0
answers
17
views
Week 7 Movies - 13.sql Query Running Forever
Title is a bit of a lie because I didn't sit around for ages waiting to see if the query will end up executing or not. However, I really can't find a reason for why this query would take so long to ...
- 1
0
votes
1
answer
37
views
cs50x Ps7 Movies 10.sql
On the Pset page it says that the solution must have 3392 rows. I wrote two different solutions, both accepted by check50, with different number of rows.
The first one gives 3389 lines:
SELECT ...
0
votes
0
answers
27
views
What's wrong with my 13.sql querry? PSET-Movies WEEK 7: SQL
I've been doing this Pset and I've completed all except for the last one. I was trying to figure out why. I think my result is ok because has the correct number of rows and Kevin Bacon doesn't appear ...
0
votes
0
answers
28
views
What's wrong in this query?
Why this query outputs just 61 rows instead of more than 185?
I 'm trying to do 13.sql
SELECT name FROM people WHERE id = (SELECT person_id FROM STARS JOIN people ON people.id = stars.person_id WHERE ...
0
votes
2
answers
4k
views
pset7 movies sql7
I'm doing the pset8 tasks.
Currently, I have some issues with sql7.
In 7.sql, write a SQL query to list all movies released in 2010 and their ratings, in descending order by rating. For movies with ...
0
votes
2
answers
162
views
How can I check my number of rows on pset7 movies?
I wanted to check my queries one by one as I am doing them, my 1.sql works fine but how I find out how many rows I am getting?
1
vote
1
answer
170
views
Submit50 for pset7 movies loads SQL files but returns "Error when executing query: missing statement"
When I execute:
submit50 cs50/problems/2020/x/movies
All my SQL files are sent for grading and all come back with the same error: Error when executing query: missing statement
I have tried the sql ...
0
votes
1
answer
113
views
How to exclude 'Kevin Bacon's' name from query table?
i have tried to exclude the name from the list but most of the solution aren't doing anything. anyone have idea how to solve.
SELECT name FROM movies JOIN
stars ON movies.id=stars.movie_id JOIN
...
0
votes
1
answer
318
views
Pset7 (Movies) 12.sql: Table outputs 96 rows rather than 5 rows
I've been stuck on this for quite some time and did a lot of research on the AND operator in SQL, but no matter how many variations I try I cannot get my table to output just 6 rows, with each row ...
- 23
0
votes
1
answer
183
views
Pset7 Movies Q12: I don't get what's wrong
I can't figure out why my pset7 movies Q12 code isn't working. Can anyone tell me why?
Here is my code:
SELECT DISTINCT title FROM movies, stars, people WHERE movie_id IN (SELECT movie_id FROM stars ...
- 1
0
votes
1
answer
444
views
pset7 Q7: How many actors are named "Meryl"?
I am at a complete loss for something that should be very simple to find in SQLite. In the IMDB database, I have to find how many actors have the name 'Meryl', I have tried select name, count(name) ...
0
votes
1
answer
384
views
PSET7 Movies Q8 - Why these queries return different results?
I'm working on pset7 movies problem of the CS50 course and I have a question regarding 8.sql, which asks to write a SQL query to list the names of all people who starred in Toy Story.
To my ...
- 3
0
votes
1
answer
710
views
pset7/movies/13.sql: exclude Kevin Bacon from the resulting list
In pset7/movies, I want to dynamically exclude Kevin Bacon from the resulting list (e.g. not specifically mentioning his name with NOT or EXCEPT or copying and pasting code that calculates his ID, so ...
0
votes
1
answer
1k
views
Pset7 8.sql is not giving output
i am in problem set 7 now, and i'm stuck in '8.sql'. Specifications is to write a SQL query to list the names of all people who starred in Toy Story. When i run my code, i get no output, i have ...
- 41
0
votes
1
answer
590
views
pset7 3.sql wrong number of rows
when writing a query to produce a table that lists the titles of all movies with a release date on or after 2018, in alphabetical order I produce a table with 35,755 rows. The CS50 pset states that I ...
- 5
1
vote
2
answers
4k
views
PSET7 Movies Q9: Why is my number of rows generated different from what the assignment requires?
Here are the parameters for running a SQL query in the file 9.sql:
In 9.sql, write a SQL query to list the names of all people who starred in a movie released in 2004, ordered by birth year.
...
2
votes
3
answers
3k
views
pset7 movies Q12
I'm stuck in PSET7 SQL part 1 question 12:
I want to list all movies with 2 people inside.
The JOIN of the 3 table is set, the problem is in my WHERE statement:
WHERE people.name = 'Johnny Depp' ...
- 153