From the course: Learning Data Analytics: 1 Foundations

Solution: Reading SQL

From the course: Learning Data Analytics: 1 Foundations

Solution: Reading SQL

“

- [Instructor] So, how'd it go? Hopefully this helped you test your data skills a little bit with reading SQL statements. Let me show you what I came up with. So far our first statement that we looked at I would make a note. This syntax lists the fields in the order of the select statement from a table name SalesOrderHeader. It then sorts the information starting with OrderDate and then DueDate. Now for the next one, it's almost the same thing except there's a problem in this one. Correct the order of the Order By and Where statements. You must filter before you sort. Once corrected, this statement lists the fields in this order from a table named SalesOrderHeader. It only shows customers with IDs that are 5-4-5, 6-8-9, and 7-5-5. And then sorts by OrderDate and DueDate. Now it's important to understand that reading SQL statements is not just for a hardcore data scientist. There are some companies that at the base level of their companies, the entry-level positions, they're having to read SQL scripts to determine where information is stored. Now that's not every company, but it's some of them. And if you got it, great. And if you didn't, that's okay too. It takes a while to learn how to read SQL statements but just keep practicing. You'll get it.

Contents