From the course: Learning Data Analytics: 1 Foundations

Challenge: Reading SQL

From the course: Learning Data Analytics: 1 Foundations

Challenge: Reading SQL

“

(upbeat music) - [Instructor] You ready for our challenge? You want to test your skills? I've provided you some SQL code in an exercise handout and on the screen. I want you to read the SQL statement below and then document or text what you believe the SQL statement will do, and if you spot any errors, what you would correct. Here's what I mean. Here's your SQL statement. I would say that this statement would actually create a list of these fields in this order from a table called SalesOrderHeader. Now this may seem tedious or not important, but I can't tell you how many times people go to job interviews and they're given statements and asked these questions. This should only take you a few minutes and here's a tip. Some of these statements are not correct. When you're done, check out the next video and see how I approached it.

Contents