{"id":144785,"date":"2025-09-27T04:27:59","date_gmt":"2025-09-27T04:27:59","guid":{"rendered":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/"},"modified":"2025-09-27T04:27:59","modified_gmt":"2025-09-27T04:27:59","slug":"sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question","status":"publish","type":"post","link":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/","title":{"rendered":"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question"},"content":{"rendered":"<div class=\"youtubomatic-video-container\"><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/www.youtube.com\/embed\/RGv1iCCFNCw?autoplay=1&#038;controls=1&#038;hl=en\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>Learn how to solve a real-world SQL beginner portfolio project step by step. In this video, we answer the question: Which are the top 5 products by total quantity sold?<\/p>\n<p>We\u2019ll use the products and orderdetails tables, join them on product_id, apply the SUM function, group results, order them in descending order, and finally use LIMIT to get the top 5.<\/p>\n<p>This video is perfect for beginners, data analytics learners, and anyone preparing for SQL interview questions. By the end, you\u2019ll understand how to combine tables, use aggregate functions, and write professional queries for your portfolio projects.<\/p>\n<p>\ud83d\udcbe Source Code &#038; Dataset:<br \/>\n<a href=\"https:\/\/github.com\/Sudais-shah\/SQL-Sales-Analytics-Project\" target=\"_blank\">https:\/\/github.com\/Sudais-shah\/SQL-Sales-Analytics-Project<\/a><br \/>\nI\u2019ll keep updating it as new queries are added to the playlist.<\/p>\n<p>#SQLBeginnerProject, #SQLPortfolio, #SQLQueries, #SQLForDataAnalytics, #SQLInterviewQuestions, #LearnSQL, #dataanalytics , #SQLTutorial, #SQLProjects, #SQLPractice, #SQLForBeginners, #SQLChallenge<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to solve a real-world SQL beginner portfolio project step by step. In this video, we answer the question: Which are the top 5 products by total quantity sold? We\u2019ll use the products and orderdetails tables, join them on product_id, apply the SUM function, group results, order them in descending order, and finally use LIMIT to get the top 5. This video is perfect for beginners, data analytics learners,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":0,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[],"class_list":["post-144785","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question - UshopWell.com<\/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:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question - UshopWell.com\" \/>\n<meta property=\"og:description\" content=\"Learn how to solve a real-world SQL beginner portfolio project step by step. In this video, we answer the question: Which are the top 5 products by total quantity sold? We\u2019ll use the products and orderdetails tables, join them on product_id, apply the SUM function, group results, order them in descending order, and finally use LIMIT to get the top 5. This video is perfect for beginners, data analytics learners,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/\" \/>\n<meta property=\"og:site_name\" content=\"UshopWell.com\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-27T04:27:59+00:00\" \/>\n<meta name=\"author\" content=\"UShopWell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UShopWell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/\"},\"author\":{\"name\":\"UShopWell\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\"},\"headline\":\"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question\",\"datePublished\":\"2025-09-27T04:27:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/\"},\"wordCount\":143,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/\",\"name\":\"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question - UshopWell.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\"},\"datePublished\":\"2025-09-27T04:27:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"name\":\"UshopWell.com\",\"description\":\"The Premiere Online Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\",\"name\":\"UshopWell\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"width\":365,\"height\":359,\"caption\":\"UshopWell\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\",\"name\":\"UShopWell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"caption\":\"UShopWell\"},\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/author\\\/kburnettu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question - UshopWell.com","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:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/","og_locale":"en_US","og_type":"article","og_title":"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question - UshopWell.com","og_description":"Learn how to solve a real-world SQL beginner portfolio project step by step. In this video, we answer the question: Which are the top 5 products by total quantity sold? We\u2019ll use the products and orderdetails tables, join them on product_id, apply the SUM function, group results, order them in descending order, and finally use LIMIT to get the top 5. This video is perfect for beginners, data analytics learners,...","og_url":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/","og_site_name":"UshopWell.com","article_published_time":"2025-09-27T04:27:59+00:00","author":"UShopWell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"UShopWell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/#article","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/"},"author":{"name":"UShopWell","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc"},"headline":"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question","datePublished":"2025-09-27T04:27:59+00:00","mainEntityOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/"},"wordCount":143,"commentCount":0,"publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/","url":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/","name":"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question - UshopWell.com","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/#website"},"datePublished":"2025-09-27T04:27:59+00:00","breadcrumb":{"@id":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ushopwell.com\/ublog\/sql-beginner-portfolio-project-top-5-products-by-quantity-sold-sql-interview-question\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ushopwell.com\/ublog\/"},{"@type":"ListItem","position":2,"name":"SQL Beginner Portfolio Project | Top 5 Products by Quantity Sold | SQL Interview Question"}]},{"@type":"WebSite","@id":"https:\/\/ushopwell.com\/ublog\/#website","url":"https:\/\/ushopwell.com\/ublog\/","name":"UshopWell.com","description":"The Premiere Online Marketplace","publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ushopwell.com\/ublog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ushopwell.com\/ublog\/#organization","name":"UshopWell","url":"https:\/\/ushopwell.com\/ublog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","width":365,"height":359,"caption":"UshopWell"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc","name":"UShopWell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","caption":"UShopWell"},"url":"https:\/\/ushopwell.com\/ublog\/author\/kburnettu\/"}]}},"_links":{"self":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/144785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/comments?post=144785"}],"version-history":[{"count":0,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/144785\/revisions"}],"wp:attachment":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media?parent=144785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/categories?post=144785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/tags?post=144785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}