April 2015 “Fun with SQL” third Challenge
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it. People can respond to the challenge in the comments section of the blog post, or they can email Kurt directly at email@example.com with a solution or idea and he will post it to the blog. You can post a possible answer, ask a question, and comment on something someone else has posted, or offer alternatives to something that’s been posted. Don’t be shy about posting your answer if someone else has already posted. At the end of the month, the content committee will take the names of the people that have participated and randomly select one to receive a reward of an IPad case, courtesy of IBM! So, don’t be shy, just dive in and share your experience or inexperience and get a free and fun education!
This week we will focus on XML and SQL. Here is the third SQL challenge, it's twofold and based upon the DB2 sample database.
- Retrieve the information from the XML column “description” from the product table
- Provide a list of all product names (but just the names) out of the product description where part of the name is “Scraper”