From the course: Learning SQL Programming

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Solution: Practice working with data

Solution: Practice working with data - SQL Tutorial

From the course: Learning SQL Programming

Start my 1-month free trial

Solution: Practice working with data

“

(upbeat music) - [Instructor] Let's take a look at my solutions to this challenge. I've used one statement here to add the two people, and if you used one statement each, that's fine too. I'll run this, and then let's take a look at what's in the database now. I have 1,002 rows returned, and down here at the bottom, there's my two new entries. Because I didn't provide a value for Walter's age, that's null, but the database has stored these records for us. Here in DB Browser, I'll click to save. Let's move on to the changes that we need to make. Bonnie Brooks has let us know that she would like to change her choice of souvenir from a hat to a shirt, so we need to take care of that. To do that, this is the statement that I wrote. But before I run that, I should check to make sure there's only one person with that name. I'll select this query to run it, and there's just one person with this name, looks good. So I'll run…

Contents