I am trying to recreate the query in the lesson counting how many airplanes* CR2 or A81 left or landed in the KZN airport: I am entering the query in the terminal using .count() at the end and keep coming up with 0 rather than the number in the lecture video. Am I doing something wrong?
I do not see anything wrong with your query.
The most likely cause is that you are not using the appropriate database. You need to use the use command. In this case, I believe that the database is named sample_training. So you would need to issue the command:
@shelbs, please mark my post as the solution if your issue is solved. If it is not solved please followup. Thanks for keeping this forum efficient.
This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.