...

/

Solution Review: Write a Generalized Query

Solution Review: Write a Generalized Query

Let's review the solution to the previous challenge.

Solution: a nested query querying person

SELECT CreatedTimestamp, Body
FROM journal_entries
WHERE PersonId =
(SELECT PersonId
FROM person
WHERE FirstName = "Frankie" AND LastName = "Manning");

Explanation

Let’s take a look at what makes up this SQL statement. We’ve already seen the first 3 lines in the ...