Challenge: Write a Generalized Query

Let's try an exercise to write a generalized SQL query.

Problem statement

Write an SQL query that returns the Body and CreatedTimestamp of all the journal entries based on a first and last name.

Sample input

FirstName = “Frankie”
LastName = “Manning”

Sample output

CreatedTimestamp Body
2020-04-21 11:28:00 Everybody shim sham!
2020-04-21 11:28:00 Time for lindy hop.

Coding exercise

Try to recall SQL nesting for this one. Good luck!

Get hands-on with 1000+ tech skills courses.