{"id":3284,"date":"2018-10-26T14:08:36","date_gmt":"2018-10-26T14:08:36","guid":{"rendered":"https:\/\/solutionstreet.com\/blog\/?p=3284"},"modified":"2018-10-26T14:08:36","modified_gmt":"2018-10-26T14:08:36","slug":"sql-exploration","status":"publish","type":"post","link":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/","title":{"rendered":"SQL Exploration"},"content":{"rendered":"

\"explorerAtitle<\/a><\/p>\n

 <\/p>\n

I\u2019m currently working in a primarily front-end role and I haven\u2019t needed to use much SQL other than an occasional basic SELECT statement. That said, having a baseline level of competency in SQL is important for any developer. To continue my growth, I decided to take a dive back into S<\/strong>tructured Q<\/strong>uery L<\/strong>anguage. My goal was to get a better grip on the basics and begin to explore some more advanced concepts. This article chronicles my exploration and provides explanations and examples for utilizing some aggregate functions as well as joins and groupings.<\/p>\n

 <\/p>\n

Quick note before we begin: All of the SQL written in this article is \u201cstandard ANSI\u201d SQL and should work on any ANSI-compliant database. Different database engines (i.e., MySQL, PostgreSQL, Oracle) come with their own custom SQL functions, syntax, etc., that build on the ANSI standard, but it is usually best to stick to the standard unless you need some database-specific feature or function.<\/p>\n

 <\/p>\n

Getting Started<\/strong><\/p>\n

 <\/p>\n

First, I needed sample data. Some searching led me to this database<\/a> of fake employee data. It has several tables filled with information including names, birth dates, hire dates, salaries, departments, and titles – an ideal data set to play around with.<\/p>\n

 <\/p>\n

Next, I needed a simple way to write SQL statements and view the results. This is achieved by setting up a simple MySQL or PostgreSQL database, and using one of many free apps available for either Mac or Windows to view the schema and run queries. If you don\u2019t feel like taking the time to set up your own database but would like to follow along, you can view the schema here<\/a> and skip to the next section.<\/p>\n

 <\/p>\n

If you\u2019d like to test out some SQL using this database, I would recommend starting with MySQL simply because it\u2019s easiest to set up. If you don\u2019t already have MySQL installed on your machine, follow these instructions<\/a> to get started. Once MySQL has been installed, open up a terminal (OS X) or command prompt (Windows) and clone the sample database using the following command:<\/p>\n

 > git clone https:\/\/github.com\/datacharmer\/test_db\/\n<\/pre>\n
 <\/p>\n
Then run:<\/p>\n
 > mysql < employees.sql\n<\/pre>\n
 <\/p>\n
If the above command doesn\u2019t work, you may need to run it as the root user:<\/p>\n
 > mysql < employees.sql -u root -p\n<\/pre>\n
 <\/p>\n
Then enter your root password. (The default is \u201cpassword\u201d.)<\/p>\n
 <\/p>\n
You can test the installation by running:<\/p>\n
 > mysql -t < test_employees_md5.sql\n<\/pre>\n
 <\/p>\n
Once your database is set up, you\u2019ll need a way to run some queries. MySQL Workbench<\/a> is the official graphical user interface (GUI) tool for MySQL and will be perfect for our purposes. After it\u2019s installed, open it up and you should see a local instance under the MySQL Connections<\/em> header. Click on the instance. If prompted, enter your password. Now you should be taken to the main screen of the app. On the left sidebar, look for the SCHEMAS<\/em> section, where you\u2019ll find a list of databases (or just one database). Double click employees<\/em>, and the text should turn bold. Our sample database is now ready for SQL querying! You can type your queries in the Query window. Click the lightning bolt icon to execute.<\/p>\n
 <\/p>\n
Next, I\u2019m going to go ahead and jump into some technical explanations beginning with aggregate functions. If you haven\u2019t gotten the hang of simple SELECT \/ WHERE statements yet, it might make sense to get a feel for how a basic SQL query is formatted, then come back. (W3Schools<\/a> is a great place to start!) Otherwise, let\u2019s get into it.<\/p>\n
 <\/p>\n
\u201c<\/span>[H]aving a baseline level of competency in SQL is important for any developer.<\/em>\u201d<\/span><\/div>\n
 <\/p>\n
Aggregate Functions<\/strong><\/p>\n
 <\/p>\n
An aggregate function performs a calculation on a set of values and returns a single value. In the following section, we\u2019ll walk through some of the most commonly used SQL aggregate functions: COUNT<\/strong>, SUM<\/strong>, MAX\/MIN<\/strong>, and AVG<\/strong>. We\u2019ll also make use of ROUND<\/strong>, which, although it\u2019s not an aggregate function, will be particularly useful in conjunction with AVG.<\/p>\n
 <\/p>\n
It is generally good practice to add AS [name]<\/strong> to the SELECT line of aggregate queries. AS is used to assign variable names to the result columns.<\/p>\n
 <\/p>\n
COUNT()<\/strong> will return a number with the amount of rows that fit the specified criteria. It takes in an argument, but because COUNT simply returns a number of rows, that argument will often be a simple asterisk (*) which, in SQL terms, means \u201call columns\u201d. If you instead choose to pass in a specific column, any rows that have a NULL value for that column will not be counted. Here is an example from the employee<\/em> database using asterisk as the argument:<\/p>\n
SELECT COUNT(*) AS employee_count\nFROM employees\nWHERE birth_date > '1960-01-01';\n\nemployee_count\n117075\n<\/pre>\n
 <\/p>\n
The query above shows us that a total of 117,075 employees were born after (but not including) January 1st, 1960.<\/p>\n
 <\/p>\n
SUM()<\/strong>\u200a will -\u200aas you\u2019d expect\u200a - \u200areturn the sum of a numeric column. If we want to see the sum of all salaries, we would write the following query:<\/p>\n
SELECT SUM(salary) AS 'salaries_totalled'\nFROM salaries;\n\nsalaries_totalled\n181480757419\n<\/pre>\n
 <\/p>\n
Once we add joins and grouping to the mix, SUM will become more useful. Let\u2019s come back to this one a bit later.<\/p>\n
 <\/p>\n
MAX() \/ MIN()<\/strong> will return the maximum or minimum value of a numeric column. Let\u2019s query the salaries table once again and use MAX() to find the highest salary:<\/p>\n
SELECT MAX(salary) AS 'highest_salary'\nFROM salaries;\n\nhighest_salary\n158220\n<\/pre>\n
 <\/p>\n
AVG()<\/strong> also takes in a numeric column and returns\u200a - \u200ayou guessed it\u200a - \u200athe average of the values for that column.<\/p>\n
 <\/p>\n
ROUND()<\/strong> is slightly different in that it takes two arguments\u200a - \u200aa column and the number of desired decimal places. It can be useful in conjunction with AVG like:<\/p>\n
SELECT ROUND(AVG(salary), 2) AS 'avg_salary'\nFROM salaries;\n\navg_salary\n63810.74\n<\/pre>\n
 <\/p>\n
which will return the average salary rounded to the nearest cent; $63,810.74 in our case.<\/p>\n
 <\/p>\n
Joins and Grouping<\/strong><\/p>\n
 <\/p>\n
The JOIN command allows us to access data from more than one table. The syntax of a JOIN line is as follows:<\/p>\n
JOIN \nON . = .\n<\/pre>\n
 <\/p>\n
The primary key<\/strong> serves as a unique identifier for each row. It is good practice to have a primary key column on every table.<\/p>\n
 <\/p>\n
The foreign key<\/strong> is a reference to the primary key of another table. In our case, we have an emp_no column on the titles<\/em> table. This allows us to join the employees<\/em> and titles<\/em> tables together by matching the primary key of employees<\/em> to the foreign key on titles<\/em>. This key-matching occurs after the keyword, ON<\/strong>. Once a JOIN is introduced to a query, column names must be prefaced by their respective table names followed by a period.<\/p>\n
 <\/p>\n
Generally, aggregate functions can become a lot more useful when GROUP BY<\/strong> is added to the mix. Instead of simply finding an aggregate of all<\/em> values in a particular column, it allows us to be more specific. For example, using JOIN and GROUP BY we can find the number of employees with each title:<\/p>\n
SELECT COUNT(*) AS 'num_of_employees', titles.title AS 'title'\nFROM employees\nJOIN titles ON titles.emp_no = employees.emp_no\nGROUP BY titles.title;\n\nnum_of_employees\ttitle\n15128\t \t\tAssistant Engineer\n115003\t \t        Engineer\n24\t \t\tManager\n97750\t \t\tSenior Engineer\n92853\t \t\tSenior Staff\n107391 \t\t        Staff\n15159\t \t\tTechnique Leader\n<\/pre>\n
 <\/p>\n
Now, instead of counting employees, what if we wanted to find the average salary by title?<\/p>\n
SELECT AVG(salaries.salary) AS 'avg_salary', titles.title AS 'title'\nFROM salaries\nJOIN employees ON employees.emp_no = salaries.emp_no\nJOIN titles ON titles.emp_no = employees.emp_no\nGROUP BY titles.title;\n\navg_salary\ttitle\n59304.9863\tAssistant Engineer\n59508.0397\tEngineer\n66924.2706\tManager\n60543.2191\tSenior Engineer\n70470.8353\tSenior Staff\n69309.1023\tStaff\n59294.3742\tTechnique Leader\n<\/pre>\n
 <\/p>\n
Looks like the average salaries for each title are pretty similar at this company. (Likely a result of the randomly generated data we are using.)<\/p>\n
 <\/p>\n
Because salaries are on their own table, we had to use another JOIN. We took the average FROM salaries<\/em>, joined employees<\/em> ON the salaries<\/em> table, then joined titles<\/em> by matching up keys with employees<\/em>. Finally, we grouped by the titles.title<\/em> column once again. Due to the large number of decimals in those averages, we probably could have benefited from using the ROUND function.<\/p>\n
 <\/p>\n
For our next example, we\u2019ll count the number of employees in each department:<\/p>\n
SELECT COUNT(*) AS 'employee_count', departments.dept_name AS 'dept_name'\nFROM employees\nJOIN dept_emp ON dept_emp.emp_no = employees.emp_no\nJOIN departments ON dept_emp.dept_no = departments.dept_no\nGROUP BY departments.dept_name;\n\nemployee_count\t        dept_name\n23580\t\t\tCustomer Service\n85707\t\t\tDevelopment\n17346\t\t\tFinance\n17786\t\t\tHuman Resources\n20211\t\t\tMarketing\n73485\t\t\tProduction\n20117\t\t\tQuality Management\n21126\t\t\tResearch\n52245\t\t\tSales\n<\/pre>\n
 <\/p>\n
This one is a bit more complicated than you might expect because the departments<\/em> table cannot be joined on employees<\/em> as they share a many-to-many relationship<\/strong>. An employee can belong to several departments, and each department can have many employees. With a many-to-many relationship, neither table contains a foreign key for the other.<\/p>\n
 <\/p>\n
Instead, a join table<\/strong> is used. In our case, that is dept_emp<\/em>. The dept_emp<\/em> table does not contain any data other than emp_no, dept_no, and the start and end dates:<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
Let\u2019s add one more piece to our previous query. If we want to only return the departments that have more than 125 employees, we would use a HAVING<\/strong> clause:<\/p>\n
SELECT COUNT(*) AS 'employee_count', departments.dept_name AS 'dept_name'\nFROM employees\nJOIN dept_emp ON dept_emp.emp_no = employees.emp_no\nJOIN departments ON dept_emp.dept_no = departments.dept_no\nGROUP BY departments.dept_name\nHAVING COUNT(*) > 50000;\n\nemployee_count\t        dept_name\n85707\t\t\tDevelopment\n73485\t\t\tProduction\n52245\t\t\tSales\n<\/pre>\n
 <\/p>\n
The way I think of HAVING is\u200a - \u200ait works just like WHERE, but it can only be used in conjunction with GROUP BY.<\/p>\n
 <\/p>\n
Types of Joins<\/strong><\/p>\n
 <\/p>\n
Until this point, every JOIN in the examples we have used has been an INNER JOIN<\/strong>. (Also known as a simple join.) This is the most common type of JOIN. It returns only the rows that have matching values in both tables.<\/p>\n
 <\/p>\n
There are three additional types of joins, and they could all be generally characterized as OUTER joins. In each case, the keyword OUTER is optional.<\/p>\n
 <\/p>\n
LEFT OUTER JOIN<\/strong> returns all<\/em> rows from the table mentioned first (the \u201cleft\u201d table) along with the rows from the other table whose values match up with the first. The following example would return all employees, even if they don\u2019t have a title. Using an inner join would have omitted those titleless employees. (Unfortunately our sample data doesn\u2019t have any employees who are missing titles.):<\/p>\n
SELECT employees.last_name, titles.title\nFROM employees\nLEFT JOIN titles ON employees.emp_no = titles.emp_no;\n<\/pre>\n
 <\/p>\n
RIGHT OUTER JOIN<\/strong> does almost exactly the same thing, but it returns all rows from the second (\u201cright\u201d) table mentioned instead. For the visual learners, let\u2019s take the above example and flip it around using RIGHT JOIN to achieve the same result:<\/p>\n
SELECT employees.first_name, titles.title\nFROM titles\nRIGHT JOIN employees ON employees.emp_no = titles.emp_no;\n<\/pre>\n
 <\/p>\n
The third type of outer join is a FULL OUTER JOIN. This can be written like the two above examples and simply returns all rows from both tables mentioned. Matching rows will be represented as a single row, and for rows that do not have a match, the result set will have NULL for all columns of the table without a matching row.<\/p>\n
 <\/p>\n
I found these diagrams from W3Schools<\/a> to be a helpful way to visualize the different types of joins:<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
To dig a bit deeper into joins, check out the Join_SQL Wikipedia<\/a> page. It contains more thorough explanations, examples, and information on less common types of joins. (This includes the CROSS JOIN<\/strong> which returns the Cartesian product of rows from the tables in the join; in other words, all possible combinations of rows.)<\/p>\n
 <\/p>\n
Conclusion<\/strong><\/p>\n
 <\/p>\n
Going through these examples helped me gain a better understanding of SQL principles, and I hope this has been helpful for you as well. If you haven\u2019t already done so, I would encourage you to download the sample data<\/a> and set it up with a GUI tool so you can practice running queries of your own.<\/p>\n
 <\/p>\n
Now that I feel I have a decent grasp on some of the most common SQL functions, I plan to learn about performance tuning. I see that topic come up quite a bit on my current project, and I can imagine it being incredibly useful for future endeavors.<\/p>\n
 <\/p>\n
Happy Sequeling!<\/p>\n","protected":false},"excerpt":{"rendered":"
  I\u2019m currently working in a primarily front-end role and I haven\u2019t needed to use much SQL other than an occasional basic SELECT statement. That said, having a baseline level of competency in SQL is important for any developer. To continue my growth, I decided to take a dive back into Structured Query Language. My […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3284","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nSQL Exploration - Solution Street Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Exploration - Solution Street Blog\" \/>\n<meta property=\"og:description\" content=\"  I\u2019m currently working in a primarily front-end role and I haven\u2019t needed to use much SQL other than an occasional basic SELECT statement. That said, having a baseline level of competency in SQL is important for any developer. To continue my growth, I decided to take a dive back into Structured Query Language. My […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/\" \/>\n<meta property=\"og:site_name\" content=\"Solution Street Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-26T14:08:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionstreet.com\/blog\/wp-content\/uploads\/2018\/10\/explorerAtitle-copy-300x225.png\" \/>\n<meta name=\"author\" content=\"Peggy Frankel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Peggy Frankel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/\"},\"author\":{\"name\":\"Peggy Frankel\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/#\\\/schema\\\/person\\\/c4846451eff30e9514b534b2a2e01696\"},\"headline\":\"SQL Exploration\",\"datePublished\":\"2018-10-26T14:08:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/\"},\"wordCount\":1849,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/solutionstreet.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/explorerAtitle-copy-300x225.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/\",\"url\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/\",\"name\":\"SQL Exploration - Solution Street Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/solutionstreet.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/explorerAtitle-copy-300x225.png\",\"datePublished\":\"2018-10-26T14:08:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/#\\\/schema\\\/person\\\/c4846451eff30e9514b534b2a2e01696\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/solutionstreet.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/explorerAtitle-copy-300x225.png\",\"contentUrl\":\"https:\\\/\\\/solutionstreet.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/explorerAtitle-copy-300x225.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/2018\\\/10\\\/26\\\/sql-exploration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Exploration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/\",\"name\":\"Solution Street Blog\",\"description\":\"Quality Software Engineering - Technology and Consulting Articles\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/#\\\/schema\\\/person\\\/c4846451eff30e9514b534b2a2e01696\",\"name\":\"Peggy Frankel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af71ceb16f89d32c9bb825a47f8057da9283b4a27a934bf0c47cdef65ad0eb5d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af71ceb16f89d32c9bb825a47f8057da9283b4a27a934bf0c47cdef65ad0eb5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af71ceb16f89d32c9bb825a47f8057da9283b4a27a934bf0c47cdef65ad0eb5d?s=96&d=mm&r=g\",\"caption\":\"Peggy Frankel\"},\"url\":\"https:\\\/\\\/www.solutionstreet.com\\\/blog\\\/author\\\/pfrankel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Exploration - Solution Street Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/","og_locale":"en_US","og_type":"article","og_title":"SQL Exploration - Solution Street Blog","og_description":"  I\u2019m currently working in a primarily front-end role and I haven\u2019t needed to use much SQL other than an occasional basic SELECT statement. That said, having a baseline level of competency in SQL is important for any developer. To continue my growth, I decided to take a dive back into Structured Query Language. My […]","og_url":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/","og_site_name":"Solution Street Blog","article_published_time":"2018-10-26T14:08:36+00:00","og_image":[{"url":"https:\/\/solutionstreet.com\/blog\/wp-content\/uploads\/2018\/10\/explorerAtitle-copy-300x225.png","type":"","width":"","height":""}],"author":"Peggy Frankel","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Peggy Frankel","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#article","isPartOf":{"@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/"},"author":{"name":"Peggy Frankel","@id":"https:\/\/www.solutionstreet.com\/blog\/#\/schema\/person\/c4846451eff30e9514b534b2a2e01696"},"headline":"SQL Exploration","datePublished":"2018-10-26T14:08:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/"},"wordCount":1849,"commentCount":0,"image":{"@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionstreet.com\/blog\/wp-content\/uploads\/2018\/10\/explorerAtitle-copy-300x225.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/","url":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/","name":"SQL Exploration - Solution Street Blog","isPartOf":{"@id":"https:\/\/www.solutionstreet.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#primaryimage"},"image":{"@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionstreet.com\/blog\/wp-content\/uploads\/2018\/10\/explorerAtitle-copy-300x225.png","datePublished":"2018-10-26T14:08:36+00:00","author":{"@id":"https:\/\/www.solutionstreet.com\/blog\/#\/schema\/person\/c4846451eff30e9514b534b2a2e01696"},"breadcrumb":{"@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#primaryimage","url":"https:\/\/solutionstreet.com\/blog\/wp-content\/uploads\/2018\/10\/explorerAtitle-copy-300x225.png","contentUrl":"https:\/\/solutionstreet.com\/blog\/wp-content\/uploads\/2018\/10\/explorerAtitle-copy-300x225.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.solutionstreet.com\/blog\/2018\/10\/26\/sql-exploration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.solutionstreet.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Exploration"}]},{"@type":"WebSite","@id":"https:\/\/www.solutionstreet.com\/blog\/#website","url":"https:\/\/www.solutionstreet.com\/blog\/","name":"Solution Street Blog","description":"Quality Software Engineering - Technology and Consulting Articles","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.solutionstreet.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.solutionstreet.com\/blog\/#\/schema\/person\/c4846451eff30e9514b534b2a2e01696","name":"Peggy Frankel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/af71ceb16f89d32c9bb825a47f8057da9283b4a27a934bf0c47cdef65ad0eb5d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/af71ceb16f89d32c9bb825a47f8057da9283b4a27a934bf0c47cdef65ad0eb5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af71ceb16f89d32c9bb825a47f8057da9283b4a27a934bf0c47cdef65ad0eb5d?s=96&d=mm&r=g","caption":"Peggy Frankel"},"url":"https:\/\/www.solutionstreet.com\/blog\/author\/pfrankel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/posts\/3284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/comments?post=3284"}],"version-history":[{"count":0,"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/posts\/3284\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/media?parent=3284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/categories?post=3284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.solutionstreet.com\/blog\/wp-json\/wp\/v2\/tags?post=3284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}