How many times does Laravel 5.7 execute the SQL query?

Learning Laravel 5.7 on Laracasts.com, it shown how to get 1:N relationship records from the database with Eloquent model objects as following.

// One SQL query is being executed here.
$project = Project::first();

// Another SQL query must be executed here to be abled to count the tasks. Right?
if ($project->tasks->count()) {

    // Is another SQL query being executed here to fetch the task's  records related to the project? 
    foreach ($project->tasks as $task) {

         echo $task->name;
    }
}

How many SQL query has been executed with the above approach? I am not sure 2 or 3 SQL queries are being executed.

via Chebli Mohamed