I have an issue I really don’t understand. In fact, I have a database of movies where there’s a table for actors,containing two colums (movie id and name). For example, then I enter the movie id of …
Tag: db-browser-sqlite
Timestamps and addition of weeks
My query requires me to find the number of people positive and their infectious periods which is plus and minus 2 weeks. In my query below I keep getting null in my 2 weeks Timestamp What is wrong with my equation and why won’t it add the 2 weeks in the next column? In DB browser this is the format
Foreign Key Constraint Failed – Even when I try to manually add data
I am studying SQL in my data science degree program, and the assignment is to perform SQL queries for the first time. In order to do that, I have to paste the SQL starter code in and run it. However,…