Data Exploration

Data Exploration - SQL 1

I explored this dataset using several SQL queries. Scroll to the bottom of the first sheet for my data exploration. The second sheet contains a scatter chart exploring the relationship between prices and invoice dates in the dataset.

</div> </div> <div class='post-footer'> <div class='post-footer-line post-footer-line-1'> </div> </div> </div> </div> <section class='comments' data-num-comments='0' id='comments'> <a name='comments'></a> </section> </div> </div> </div> </div> </main> </div> <footer class='footer section' id='footer' name='Footer'><div class='widget Attribution' data-version='2' id='Attribution1'> <div class='widget-content'> <div class='blogger'> <a href='https://www.blogger.com' rel='nofollow'> <svg class='svg-icon-24'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_post_blogger_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> Powered by Blogger </a> </div> </div> </div></footer> </div> </div> <aside class='sidebar-container container sidebar-invisible' role='complementary'> <div class='navigation'> <svg class='svg-icon-24 touch-icon sidebar-back rtl-reversible-icon'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_arrow_back_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> </div> <div class='section' id='sidebar' name='Sidebar'><div class='widget Profile' data-version='2' id='Profile1'> <div class='widget-content individual'> <a href='https://www.blogger.com/profile/06990795081191581859' rel='nofollow'> <img alt='My photo' class='profile-img' height='120' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrFHoI420hDW9dX2ZVWmH_uMLEZDZYhPkKjxbl8j3zHgJKKuZxEI8DJjnYB9BHn62dRNQA3gj_UFCT2YZmP8hRG4jUFUIGqnrtoPy3uVMO5XYjIBGn4C_ZeOTkWHsDSHNR5ykNdztGy1ZYHeeq2akfv73xeAUFXmiEeR_aCCr42CS2vw/s220/blue%20head.png' width='120'/> </a> <div class='profile-info'> <dl class='profile-datablock'> <dt class='profile-data'> <a class='profile-link g-profile' href='https://www.blogger.com/profile/06990795081191581859' rel='author nofollow'> Tyran Jackson </a> </dt> <dd class='profile-textblock'> I connect brands to their audiences with strategic communication and data-driven digital marketing. ✨ </dd> </dl> <a class='profile-link' href='https://www.blogger.com/profile/06990795081191581859' rel='author'> Visit profile </a> </div> </div> </div><div class='widget Label' data-version='2' id='Label1'> <details class='collapsible extendable'> <summary> <div class='collapsible-title'> <h3 class='title'> Top Skills </h3> <svg class='svg-icon-24 chevron-down'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_expand_more_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <svg class='svg-icon-24 chevron-up'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_expand_less_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> </div> </summary> <div class='widget-content list-label-widget-content'> <div class='first-items'> <ul> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Adobe%20Creative%20Suite'>Adobe Creative Suite</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Analytics'>Analytics</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Article%20Writing'>Article Writing</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Canva'>Canva</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Case%20Study'>Case Study</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Email%20Marketing'>Email Marketing</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Graphic%20Design'>Graphic Design</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/InDesign'>InDesign</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Journalism'>Journalism</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Photoshop'>Photoshop</a></li> </ul> </div> <div class='remaining-items'> <ul> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Presentation'>Presentation</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Social%20Media'>Social Media</a></li> <li><a class='label-name' href='https://tyranjacksonportfolio.blogspot.com/search/label/Web%20Design'>Web Design</a></li> </ul> </div> <span class='show-more flat-button'>Show more</span> <span class='show-less hidden flat-button'>Show less</span> </div> </details> </div> <div class='widget LinkList' data-version='2' id='LinkList1'> <h3 class='title'> Connect With Me! </h3> <div class='widget-content'> <ul> <li><a href='https://www.linkedin.com/in/tyranjack5/'>LinkedIn</a></li> </ul> </div> </div> </div> </aside> <script type="text/javascript" src="https://resources.blogblog.com/blogblog/data/res/3100132956-fancy_compiled.js" async="true"></script> <script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2538535903-widgets.js"></script> <script type='text/javascript'> window['__wavt'] = 'AOuZoY6q4h1wmfVzScQQYI_atKL6UeGoHA:1744569283706';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d2050222335797441722','//tyranjacksonportfolio.blogspot.com/2025/01/blog-post_15.html','2050222335797441722'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '2050222335797441722', 'title': 'Tyran Jackson Portfolio', 'url': 'https://tyranjacksonportfolio.blogspot.com/2025/01/blog-post_15.html', 'canonicalUrl': 'https://tyranjacksonportfolio.blogspot.com/2025/01/blog-post_15.html', 'homepageUrl': 'https://tyranjacksonportfolio.blogspot.com/', 'searchUrl': 'https://tyranjacksonportfolio.blogspot.com/search', 'canonicalHomepageUrl': 'https://tyranjacksonportfolio.blogspot.com/', 'blogspotFaviconUrl': 'https://tyranjacksonportfolio.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tyran Jackson Portfolio - Atom\x22 href\x3d\x22https://tyranjacksonportfolio.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Tyran Jackson Portfolio - RSS\x22 href\x3d\x22https://tyranjacksonportfolio.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tyran Jackson Portfolio - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/2050222335797441722/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tyran Jackson Portfolio - Atom\x22 href\x3d\x22https://tyranjacksonportfolio.blogspot.com/feeds/6243321008631334600/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/3d05552398782a47', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '6243321008631334600', 'pageName': 'Data Exploration - SQL 1', 'pageTitle': 'Tyran Jackson Portfolio: Data Exploration - SQL 1'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'Soho', 'localizedName': 'Soho', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': false, 'variant': 'fancy_red', 'variantId': 'fancy_red'}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Data Exploration - SQL 1', 'description': 'I explored this dataset using several SQL queries. Scroll to the bottom of the first sheet for my data exploration. The second sheet contai...', 'url': 'https://tyranjacksonportfolio.blogspot.com/2025/01/blog-post_15.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 6243321008631334600}}, {'name': 'widgets', 'data': [{'title': 'Search This Blog', 'type': 'BlogSearch', 'sectionId': 'search_top', 'id': 'BlogSearch1'}, {'title': 'Tyran Jackson Portfolio (Header)', 'type': 'Header', 'sectionId': 'header', 'id': 'Header1'}, {'title': 'MY SKILLS', 'type': 'PageList', 'sectionId': 'page_list_top', 'id': 'PageList1'}, {'title': '', 'type': 'FeaturedPost', 'sectionId': 'page_body', 'id': 'FeaturedPost1', 'postId': '3003578370434315872'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'page_body', 'id': 'Blog1', 'posts': [{'id': '6243321008631334600', 'title': 'Data Exploration - SQL 1', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'labels', 'label': 'Skills:'}]}], 'allBylineItems': [{'name': 'labels', 'label': 'Skills:'}]}, {'type': 'Attribution', 'sectionId': 'footer', 'id': 'Attribution1'}, {'title': 'About Me', 'type': 'Profile', 'sectionId': 'sidebar', 'id': 'Profile1'}, {'title': 'Top Skills', 'type': 'Label', 'sectionId': 'sidebar', 'id': 'Label1'}, {'title': 'Connect With Me!', 'type': 'LinkList', 'sectionId': 'sidebar', 'id': 'LinkList1'}]}]); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch1', 'search_top', document.getElementById('BlogSearch1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'page_list_top', document.getElementById('PageList1'), {'title': 'MY SKILLS', 'links': [{'isCurrentPage': false, 'href': 'https://tyranjacksonportfolio.blogspot.com/p/email-marketing.html', 'id': '5054368205669156417', 'title': 'Email Marketing'}, {'isCurrentPage': false, 'href': 'https://tyranjacksonportfolio.blogspot.com/p/social-media.html', 'id': '7655146331530720704', 'title': 'Social Media'}, {'isCurrentPage': false, 'href': 'https://tyranjacksonportfolio.blogspot.com/p/articles.html', 'id': '4628065502899416008', 'title': 'SEO Content'}, {'isCurrentPage': false, 'href': 'https://tyranjacksonportfolio.blogspot.com/p/data-analytics.html', 'id': '6411408947890637800', 'title': 'Data Analytics'}, {'isCurrentPage': false, 'href': 'https://tyranjacksonportfolio.blogspot.com/p/adobe-creative-suite.html', 'id': '297203238556224875', 'title': 'Adobe Creative Suite'}, {'isCurrentPage': false, 'href': 'https://tyranjacksonportfolio.blogspot.com/p/web-design.html', 'id': '6272720487517717853', 'title': 'Website Design'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'page_body', document.getElementById('FeaturedPost1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'page_body', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3337823330-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3681588378-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_AttributionView', new _WidgetInfo('Attribution1', 'footer', document.getElementById('Attribution1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ProfileView', new _WidgetInfo('Profile1', 'sidebar', document.getElementById('Profile1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'sidebar', document.getElementById('Label1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'sidebar', document.getElementById('LinkList1'), {}, 'displayModeFull')); </script> </body> </html>