From the course: Learning SQL Programming
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Retrieve data from the database - SQL Tutorial
From the course: Learning SQL Programming
Challenge: Retrieve data from the database
(upbeat music) - [Instructor] Take a moment and practice what we've seen so far. When our quiz participants signed up, they chose whether they wanted a customized shirt or hat as a prize for participating. Now that all the quiz results are in it's time to get those awards out the door. We're working with a vendor to get these prizes into our participants' hands, but the vendor needs the participant information in order to ship the appropriate prize to the right person. The prizes will show each person's name, their team, and their quiz score. Because we have a thousand participants, the company we're working with to get the awards made has also asked us to break up the list by which prize, a shirt or a hat, each person wants, and then, to further break the list down by team so all the printing can be as organized as possible. So, all the hat people will be listed together and they'll be arranged by team and then the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.