SQL Server: Subqueries

Level : Beginner
Mentor: Shailendra Chauhan
Type : GuidedLab
Points : 10
Duration : 00:20:00

Lab Details


An SQL Subquery, is a SELECT query within another query. It is also known as Inner query or Nested query and the query containing it is the outer query.

In this lab, you will learn how to use Subqueries in SQL Server.

Based on this Customer and Supplier Schema, generate the solutions to the respective queries listed below:

  1. List all suppliers with the number of products they offer.
  2. List products with order quantities greater than 100.
  3. List all customers with their total number of orders.

Lab Objective

Upon completion of this lab, you will be able to:

  • Gain Hands-On Experience on SQL Server Subqueries


  • You should have a conceptual understanding of Subqueries.
  • You must have SQL Server Installed on your systems.

Self-paced Membership
  • 22+ Video Courses
  • 800+ Hands-On Labs
  • 400+ Quick Notes
  • 55+ Skill Tests
  • 45+ Interview Q&A Courses
  • 10+ Real-world Projects
  • Career Coaching Sessions
  • Email Support
Upto 60% OFF
Know More
Still have some questions? Let's discuss.
Accept cookies & close this