Using MySQL:
You cannot prove that a query is logically correct by looking atthe output but you can sometimes tell that a query is wrong thatway. For example- look at task 03 – we want clients with an animalthat is not a reptile. Suppose your query for task 03 brings back aclient id 2000. You can look at the rows in Task 01 to see theanimals client 2000 has. Do not give me two queries for any onetask.
Do not use any join for the tasks that require subqueries.
Tasks
Task 01: Display all clients and their animalsif they have any. Display the following:
OR
OR