Challenge: Write a Generalized Query
Let's try an exercise to write a generalized SQL query.
We'll cover the following
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 1200+ tech skills courses.