Solution: Write queries in CoderPad

(bright electronic music) - [Instructor] In this final code challenge, we're asked to retrieve some information from the Customers and the Invoices tables that we've created now that they've been populated with some rows of data. This is called querying the database, because we're asking questions of the information and we're looking for a specific answer. In this case, we're looking for the customer names and invoice information for every customer that has an invoice dated on or after March 1st, 2024. We'll get started with the keyword SELECT. This is how we pull information out of a SQL database. Then we just pull in a list of the different columns that we're interested in seeing in the results. We put those in with the name of the table. So, the first column that I want is the FirstName column coming from the Customers table. So, I'll put Customers.FirstName. That'll make that reference to that table. Then I also want the LastName column that's also coming from the Customers table.…