Skip to main content

Questions tagged [movies]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 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 ...
qwest's user avatar
  • 1
0 votes
1 answer
77 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 ...
Nicolò Tiraboschi's user avatar
0 votes
0 answers
29 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 ...
Mohamed Hassan's user avatar
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 ...
Vladimir Khudokormov's user avatar
0 votes
2 answers
166 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?
eduarda gouveia's user avatar
1 vote
1 answer
186 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 ...
Kelvin Winspinger's user avatar
0 votes
1 answer
114 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 ...
Exodus Joel's user avatar
0 votes
1 answer
328 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 ...
qwert9988's user avatar
0 votes
1 answer
188 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 ...
Miguel's user avatar
  • 1
0 votes
1 answer
461 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) ...
StimpakNeeded's user avatar
0 votes
1 answer
390 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 ...
MADi's user avatar
  • 3
0 votes
1 answer
723 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 ...
sceunazhel's user avatar
0 votes
1 answer
2k 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 ...
Robin's user avatar
  • 41
0 votes
1 answer
599 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 ...
borebot's user avatar
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. ...
Daniel Hering's user avatar
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' ...
saquiel's user avatar
  • 153