Beginner Basics for Nested Query/ Subquery in Google sheets

In this tutorial, we'll be exploring how to use the QUERY function in Google Sheets to find specific fruits in a dataset based on certain criteria. Specifically, we'll be looking at two different scenarios. In the first scenario, we'll be finding fruits whose sum of quantities is greater than a given value. This can be helpful if you're trying to find which fruits you have in abundance and which ones you need to stock up on. In the second scenario, we'll be finding fruits whose sum of quantity and sum of total cost are both greater than given values. This can be helpful if you're trying to analyze your expenses and determine which fruits are costing you the most money. We'll be working with a dataset that includes information on various fruits, including the fruit name, quantity, unit cost, and total cost. Using the QUERY function, we'll be able to easily filter through this data and find the fruits that meet our specific criteria. We'll be approaching each scenario in two steps: first, we'll use the QUERY function to filter the data based on the quantity or quantity and total cost, and then we'll use a second QUERY function to extract the fruit names from the filtered data. If you're looking to improve your data analysis skills, or you're just curious about how to use the QUERY function in Google Sheets, then this tutorial is for you!