Now that we have Composer setup, we can pull in the Laravel installer and make it accessible globally on our machine. This allows you to run a single command to build a fresh Laravel installation: laravel new app.

Laravel 6 ships with improved support for Eloquent subqueries, thanks to a few PRs from Jonathan Reinink. You may now add subqueries by using the new addSelect() method, or by passing a closure to the orderBy() and from() methods of the query builder. I'll show you how in this lesson.

Before we get started, you must first ensure that up-to-date versions of both PHP and MySQL are installed and available on your machine. In this episode, we'll review how to go about this. Once complete, we can then install Composer.