The sumbit50 site only gives me credit for 7% of the assignment. I have completed all 13 sql and they work, but I must admit I checked them through PHPliteadmin in the movies.db. the queries are all correct, but I could not get the cat 1.sql | sqlite3 movies.db to print out anything which is why I checked my codes in PHPliteadmin. I have attached sqlite code for one of the exercises to show what I have done in each sql file Saw previous posts where someone had comments and removed comments and it worked. I have NO comments. I I did not use my local machine so I am checking my code via ~/pset7/movies/ $ cat 1.sql | sqlite3 movies.db ~/pset7/movies/ $ But nothing gets returned. however the code is executed in the phplitadmin as I see the new tables and they are correct.
CREATE TABLE bd_emma_stone1(birth NUMERIC); INSERT INTO bd_emma_stone1 (birth) SELECT distinct birth FROM people WHERE name == "Emma Stone";
Movies - 7% is my grade
check50 provided the below
:( 2.sql produces correct result
Error when executing query: too many statements at once
:( 3.sql produces correct result
Error when executing query: too many statements at once
:( 4.sql produces correct result
Error when executing query: too many statements at once
:( 5.sql produces correct result
Error when executing query: too many statements at once
:( 6.sql produces correct result
Error when executing query: too many statements at once
:( 7.sql produces correct result
Error when executing query: too many statements at once
:( 8.sql produces correct result
Error when executing query: too many statements at once
:( 9.sql produces correct result
Error when executing query: too many statements at once
:( 10.sql produces correct result
Error when executing query: too many statements at once
:( 11.sql produces correct result
Error when executing query: too many statements at once
:( 12.sql produces correct result
Error when executing query: too many statements at once
:( 13.sql produces correct result
Error when executing query: too many statements at once
.