Oct 2, 2022 · Sep 30, 2022 · Sep 30, 2022 · Sep 30, 2022 · Sep 30, 2022 · Sep 30, 2022
diff --git a/03 string_window.cpp b/03 string_window.cpp
 #include<iostream>
 #include<climits>
 #include<string>
 using namespace std;

 string find_window(string s,string p){


 //Array as a Freq Map or you can hashmap
 int FP[256] = {0};
 int FS[256] = {0};

 for(int i=0;i<p.length();i++){
 FP[ps[i]]++;
 }

 //Sliding Window Algorithm
 int cnt = 0;
 int start = 0; // left contraction
 int start_idx = -1; //start_idx for best window
 int min_so_far = INT_MAX; //large number
 int window_size ;


 for(int i=0 ; i < s.length(); i++){
 //expand the window by including current character
 char ch = s[i];
 FS[ch]++;

 //Count how many characters have been matched till now (string and pattern)
 if(FP[ch]!=0 and FS[ch]<= FP[ch]){
 cnt += 1;
 }

 //another thing
 //if all characters of the pattern are found in the current window then you can start contracting
 if(cnt==p.length()){

 //start contracting from the left to remove unwanted characters

 while(FP[s[start]]==0 or FS[s[start]] > FP[s[start]]){
 FS[s[start]]--;
 start++;
 }

 //note. the window size
 window_size = i - start + 1;
 if(window_size < min_so_far){
 min_so_far = window_size;
 start_idx = start;
 }

 }

 }
 if(start_idx==-1){
 return "No window found";
 }
 return s.substr(start_idx,min_so_far);
 }



 int main(){

 string s,p;
 cin>>s>>p;


    cout<<find_window(s,p)<<endl;



 return 0;
 }
diff --git a/Amazon/AmazonSDE2_AkshatJain.pdf b/Amazon/AmazonSDE2_AkshatJain.pdf
diff --git a/Amazon/AmazonSDE3_Round1.pdf b/Amazon/AmazonSDE3_Round1.pdf
diff --git a/Amazon/AmazonSDE_AkshatJain.docx b/Amazon/AmazonSDE_AkshatJain.docx
diff --git a/Amazon/sheet1.pdf b/Amazon/sheet1.pdf
diff --git a/Amazon/sheet2.pdf b/Amazon/sheet2.pdf
diff --git a/Amazon/sheet3.pdf b/Amazon/sheet3.pdf
diff --git a/Disk Space Analysis.cpp b/Disk Space Analysis.cpp
 #include <bits/stdc++.h>
 using namespace std;
 vector<int> arr;
 int prevmin=-1;
 int flag=0;
 int x,n,q;

 int sorting(int start,int end)
 {
    if(start+1==n) {start=0;end=end-n;}
    if(start==end) return arr[start];
    return min(arr[start],sorting(start+1,end));
 }

 int func(int start,int end)
 {
    if(flag==0) {flag++;return prevmin=sorting(start,end);}
    if(arr[start-1]==prevmin) return prevmin;
    return prevmin=(arr[end]<=prevmin)?prevmin:sorting(start,end);

 }

 int main()
 {
    cin>>x>>n;
    int ans=0;
    for(int i=0;i<n;i++)
    {cin>>q;arr.push_back(q);}
    for(int i=0;i<n;i++)
    {
       ans=max(ans,func(i,i+x-1));
    }
    cout<<ans;
 }
diff --git a/Exercise Files/01_01.sql b/Exercise Files/01_01.sql
 use AdventureWorksDW2014;

 -- select all columns
 select * from FactInternetSales;

 -- limiting results
 select top 1000 * from FactInternetSales; -- in other DB's use limit 1000;

 -- select using column names
 SELECT [ProductKey]
      ,[OrderDateKey]
      ,[DueDateKey]
      ,[ShipDateKey]
      ,[CustomerKey]
      ,[PromotionKey]
      ,[CurrencyKey]
      ,[SalesTerritoryKey]
      ,[SalesOrderNumber]
      ,[SalesOrderLineNumber]
      ,[RevisionNumber]
      ,[OrderQuantity]
      ,[UnitPrice]
      ,[ExtendedAmount]
      ,[UnitPriceDiscountPct]
      ,[DiscountAmount]
      ,[ProductStandardCost]
      ,[TotalProductCost]
      ,[SalesAmount]
      ,[TaxAmt]
      ,[Freight]
      ,[CarrierTrackingNumber]
      ,[CustomerPONumber]
      ,[OrderDate]
      ,[DueDate]
      ,[ShipDate]
  FROM [dbo].[FactInternetSales]


 -- select some and use aliases
 SELECT TOP 1000
 [SalesOrderNumber] as 'OrderNumber'
      ,[SalesOrderLineNumber] as 'LineNumber'
      ,[OrderQuantity] as 'Quantity'
      ,[UnitPrice] as 'Price'
      ,[DiscountAmount] as 'Discount'
      ,[SalesAmount] as 'Sales'
      ,[TaxAmt] as 'Taxes'
      ,[OrderDate] as 'Date'
 FROM [dbo].[FactInternetSales]
diff --git a/Exercise Files/01_02.sql b/Exercise Files/01_02.sql
 use AdventureWorksDW2014;


 -- inner join
 -- returns results only where the join condition is true
 select top 1000 *
 from FactInternetSales s
 inner join DimProduct p on s.ProductKey = p.ProductKey

 -- left join
 -- returns all rows from sales, regardless of the join condition
 select distinct EnglishProductName
 from FactInternetSales s
 left join DimProduct p on s.ProductKey = p.ProductKey
 order by 1

 -- add filter conditions to join
 select *
 from FactInternetSales s
 inner join DimProduct p
 ons.ProductKey = p.ProductKey
 andp.StartDate > '2013-01-01'
diff --git a/Exercise Files/01_03.sql b/Exercise Files/01_03.sql
 use AdventureWorksDW2014;

 -- basic filter with WHERE
 -- get sales of a specific product only
 SELECT *
 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 WHERE p.EnglishProductName = 'Road-650 Black, 62'

 -- non-equi-filters
 -- get all orders for 2013
 SELECT *
 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 WHEREs.OrderDate >= '2013-01-01'
 ANDs.OrderDate <= '2013-12-31'

 -- also can use "between" for dates
 SELECT *
 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 WHERE s.OrderDate BETWEEN '2013-01-01' AND '2013-12-31';

 -- filter for multiple values using IN
 SELECT *
 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 WHERE p.EnglishProductName in(
 'Mountain-400-W Silver, 38',
 'Mountain-400-W Silver, 40',
 'Mountain-400-W Silver, 42',
 'Mountain-400-W Silver, 46')


 -- find all current and future matches with LIKE
 SELECT *
 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 WHERE p.EnglishProductName LIKE 'Mountain%' --put % where you want wildcard
diff --git a/Exercise Files/01_04.sql b/Exercise Files/01_04.sql
 use AdventureWorksDW2014;

 select OrderDate, sum(SalesAmount)
 from FactInternetSales
 group by OrderDate
 order by OrderDate

 -- simple aggregations
 -- Use additional aggregations to understand more about product sales such as distribution of sales etc..
 SELECT
 cat.EnglishProductCategoryName 'Category'
    ,sub.EnglishProductSubcategoryName 'SubCategory'
 ,count(1) 'Count' -- How many sales where there?
 ,sum(s.SalesAmount) 'Sales' -- How much sales did we have?
    ,avg(s.SalesAmount) 'Avg_SalesAmount' -- What was the Avg sale amount?
    ,min(s.SalesAmount) 'Min_SaleAmount' -- What was the Min sale amount?
    ,max(s.SalesAmount) 'Max_SaleAmount' -- What was the Max sale amount
 FROM FactInternetSales s
 LEFT JOIN DimProduct p ON s.ProductKey = p.ProductKey
 LEFT JOIN DimProductSubcategory sub ON p.ProductSubcategoryKey = sub.ProductSubcategoryKey
 LEFT JOIN DimProductCategory cat ON sub.ProductCategoryKey = cat.ProductCategoryKey
 -- must use group by in order for aggregation to work properly
 GROUP BY
 cat.EnglishProductCategoryName -- column aliases aren't allowed
    ,sub.EnglishProductSubcategoryName
 ORDER BY
 cat.EnglishProductCategoryName
 ,sub.EnglishProductSubcategoryName

 -- filter to 2013 with WHERE
 SELECT
 YEAR(s.OrderDate) 'Year'
 ,cat.EnglishProductCategoryName 'Category'
    ,sub.EnglishProductSubcategoryName 'SubCategory'
 ,count(1) 'Count' -- use 1 instead of a field for faster performance
 ,sum(s.SalesAmount) 'Sales'
    ,avg(s.SalesAmount) 'Avg_Quantity'
    ,min(s.SalesAmount) 'Min_SaleAmount'
    ,max(s.SalesAmount) 'Max_SaleAmount'

 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 INNER JOIN DimProductSubcategory sub ON p.ProductSubcategoryKey = sub.ProductSubcategoryKey
 INNER JOIN DimProductCategory cat ON sub.ProductCategoryKey = cat.ProductCategoryKey
 -- filter
 WHERE YEAR(s.OrderDate) = 2013 --use date function to parse year
 -- must use group by in order for aggregation to work properly
 GROUP BY
 YEAR(s.OrderDate)
 ,cat.EnglishProductCategoryName -- column aliases aren't allowed
    ,sub.EnglishProductSubcategoryName
 ORDER BY
 cat.EnglishProductCategoryName
 ,sub.EnglishProductSubcategoryName

 -- Only show products in 2013 that sold more than $1M USD
 SELECT
 cat.EnglishProductCategoryName 'Category'
    ,sub.EnglishProductSubcategoryName 'SubCategory'
 ,count(1) 'Count' -- use 1 instead of a field for faster performance
 ,sum(s.SalesAmount) 'Sales'
    ,avg(s.SalesAmount) 'Avg_Quantity'
    ,min(s.SalesAmount) 'Min_SaleAmount'
    ,max(s.SalesAmount) 'Max_SaleAmount'
 FROM FactInternetSales s
 INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
 INNER JOIN DimProductSubcategory sub ON p.ProductSubcategoryKey = sub.ProductSubcategoryKey
 INNER JOIN DimProductCategory cat ON sub.ProductCategoryKey = cat.ProductCategoryKey
 -- filter
 WHERE YEAR(s.OrderDate) = 2013 --use date function to parse year
 -- must use group by in order for aggregation to work properly
 GROUP BY
 cat.EnglishProductCategoryName -- column aliases aren't allowed
    ,sub.EnglishProductSubcategoryName
 -- use HAVING to filter after the aggregate is computed
 HAVING
 sum(s.SalesAmount) > 1000000
 ORDER BY
 cat.EnglishProductCategoryName
 ,sub.EnglishProductSubcategoryName
diff --git a/Exercise Files/01_05.sql b/Exercise Files/01_05.sql
diff --git a/Exercise Files/01_06.sql b/Exercise Files/01_06.sql
 use AdventureWorksDW2014;

 -- Sub Queries

 -- Use a sub-query to aggregate an underlying Table
 select *
 from (
 select sum(SalesAmount) as 'Sales', YEAR(OrderDate) as 'Yr'
 from FactInternetSales
 group by YEAR(OrderDate)
 ) YrSales

 -- Create new aggregates on to of derived
 select avg(Sales) as 'AvgSales'
 from (
 select sum(SalesAmount) as 'Sales', YEAR(OrderDate) as 'Yr'
 from FactInternetSales
 group by YEAR(OrderDate)
 ) YrSales

 -- Use a subquery to test if values are IN another table
 SELECT EnglishProductName 'Product'
 FROM DimProduct p
 WHERE p.ProductSubcategoryKey IN
    (SELECT sc.ProductSubcategoryKey
     FROM DimProductSubcategory sc
     WHERE sc.EnglishProductSubcategoryName = 'Wheels')

 -- Re-write this as a Join instead
 SELECTp.EnglishProductName
 FROMDimProduct p
 JOINDimProductSubcategory sc ON p.ProductSubcategoryKey = sc.ProductSubcategoryKey
 WHEREsc.EnglishProductSubcategoryName = 'Wheels'

 -- Use EXISTS to test if the outer queries value is present in the sub-query
 -- Somtimes this is the only way to express this join type
 SELECT EnglishProductName 'Product'
 FROM DimProduct p
 WHERE EXISTS
    (SELECT * -- no data is returned, only a boolean true/false
     FROM DimProductSubcategory sc
     WHEREp.ProductSubcategoryKey = sc.ProductSubcategoryKey
 ANDsc.EnglishProductSubcategoryName = 'Wheels')
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,75 @@
		#include<iostream>
		#include<climits>
		#include<string>
		using namespace std;

		string find_window(string s,string p){


		//Array as a Freq Map or you can hashmap
		int FP[256] = {0};
		int FS[256] = {0};

		for(int i=0;i<p.length();i++){
		FP[ps[i]]++;
		}

		//Sliding Window Algorithm
		int cnt = 0;
		int start = 0; // left contraction
		int start_idx = -1; //start_idx for best window
		int min_so_far = INT_MAX; //large number
		int window_size ;


		for(int i=0 ; i < s.length(); i++){
		//expand the window by including current character
		char ch = s[i];
		FS[ch]++;

		//Count how many characters have been matched till now (string and pattern)
		if(FP[ch]!=0 and FS[ch]<= FP[ch]){
		cnt += 1;
		}

		//another thing
		//if all characters of the pattern are found in the current window then you can start contracting
		if(cnt==p.length()){

		//start contracting from the left to remove unwanted characters

		while(FP[s[start]]==0 or FS[s[start]] > FP[s[start]]){
		FS[s[start]]--;
		start++;
		}

		//note. the window size
		window_size = i - start + 1;
		if(window_size < min_so_far){
		min_so_far = window_size;
		start_idx = start;
		}

		}

		}
		if(start_idx==-1){
		return "No window found";
		}
		return s.substr(start_idx,min_so_far);
		}



		int main(){

		string s,p;
		cin>>s>>p;


		cout<<find_window(s,p)<<endl;



		return 0;
		}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,34 @@
		#include <bits/stdc++.h>
		using namespace std;
		vector<int> arr;
		int prevmin=-1;
		int flag=0;
		int x,n,q;

		int sorting(int start,int end)
		{
		if(start+1==n) {start=0;end=end-n;}
		if(start==end) return arr[start];
		return min(arr[start],sorting(start+1,end));
		}

		int func(int start,int end)
		{
		if(flag==0) {flag++;return prevmin=sorting(start,end);}
		if(arr[start-1]==prevmin) return prevmin;
		return prevmin=(arr[end]<=prevmin)?prevmin:sorting(start,end);

		}

		int main()
		{
		cin>>x>>n;
		int ans=0;
		for(int i=0;i<n;i++)
		{cin>>q;arr.push_back(q);}
		for(int i=0;i<n;i++)
		{
		ans=max(ans,func(i,i+x-1));
		}
		cout<<ans;
		}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,49 @@
		use AdventureWorksDW2014;

		-- select all columns
		select * from FactInternetSales;

		-- limiting results
		select top 1000 * from FactInternetSales; -- in other DB's use limit 1000;

		-- select using column names
		SELECT [ProductKey]
		,[OrderDateKey]
		,[DueDateKey]
		,[ShipDateKey]
		,[CustomerKey]
		,[PromotionKey]
		,[CurrencyKey]
		,[SalesTerritoryKey]
		,[SalesOrderNumber]
		,[SalesOrderLineNumber]
		,[RevisionNumber]
		,[OrderQuantity]
		,[UnitPrice]
		,[ExtendedAmount]
		,[UnitPriceDiscountPct]
		,[DiscountAmount]
		,[ProductStandardCost]
		,[TotalProductCost]
		,[SalesAmount]
		,[TaxAmt]
		,[Freight]
		,[CarrierTrackingNumber]
		,[CustomerPONumber]
		,[OrderDate]
		,[DueDate]
		,[ShipDate]
		FROM [dbo].[FactInternetSales]


		-- select some and use aliases
		SELECT TOP 1000
		[SalesOrderNumber] as 'OrderNumber'
		,[SalesOrderLineNumber] as 'LineNumber'
		,[OrderQuantity] as 'Quantity'
		,[UnitPrice] as 'Price'
		,[DiscountAmount] as 'Discount'
		,[SalesAmount] as 'Sales'
		,[TaxAmt] as 'Taxes'
		,[OrderDate] as 'Date'
		FROM [dbo].[FactInternetSales]
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,22 @@
		use AdventureWorksDW2014;


		-- inner join
		-- returns results only where the join condition is true
		select top 1000 *
		from FactInternetSales s
		inner join DimProduct p on s.ProductKey = p.ProductKey

		-- left join
		-- returns all rows from sales, regardless of the join condition
		select distinct EnglishProductName
		from FactInternetSales s
		left join DimProduct p on s.ProductKey = p.ProductKey
		order by 1

		-- add filter conditions to join
		select *
		from FactInternetSales s
		inner join DimProduct p
		ons.ProductKey = p.ProductKey
		andp.StartDate > '2013-01-01'
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,39 @@
		use AdventureWorksDW2014;

		-- basic filter with WHERE
		-- get sales of a specific product only
		SELECT *
		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		WHERE p.EnglishProductName = 'Road-650 Black, 62'

		-- non-equi-filters
		-- get all orders for 2013
		SELECT *
		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		WHEREs.OrderDate >= '2013-01-01'
		ANDs.OrderDate <= '2013-12-31'

		-- also can use "between" for dates
		SELECT *
		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		WHERE s.OrderDate BETWEEN '2013-01-01' AND '2013-12-31';

		-- filter for multiple values using IN
		SELECT *
		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		WHERE p.EnglishProductName in(
		'Mountain-400-W Silver, 38',
		'Mountain-400-W Silver, 40',
		'Mountain-400-W Silver, 42',
		'Mountain-400-W Silver, 46')


		-- find all current and future matches with LIKE
		SELECT *
		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		WHERE p.EnglishProductName LIKE 'Mountain%' --put % where you want wildcard
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,80 @@
		use AdventureWorksDW2014;

		select OrderDate, sum(SalesAmount)
		from FactInternetSales
		group by OrderDate
		order by OrderDate

		-- simple aggregations
		-- Use additional aggregations to understand more about product sales such as distribution of sales etc..
		SELECT
		cat.EnglishProductCategoryName 'Category'
		,sub.EnglishProductSubcategoryName 'SubCategory'
		,count(1) 'Count' -- How many sales where there?
		,sum(s.SalesAmount) 'Sales' -- How much sales did we have?
		,avg(s.SalesAmount) 'Avg_SalesAmount' -- What was the Avg sale amount?
		,min(s.SalesAmount) 'Min_SaleAmount' -- What was the Min sale amount?
		,max(s.SalesAmount) 'Max_SaleAmount' -- What was the Max sale amount
		FROM FactInternetSales s
		LEFT JOIN DimProduct p ON s.ProductKey = p.ProductKey
		LEFT JOIN DimProductSubcategory sub ON p.ProductSubcategoryKey = sub.ProductSubcategoryKey
		LEFT JOIN DimProductCategory cat ON sub.ProductCategoryKey = cat.ProductCategoryKey
		-- must use group by in order for aggregation to work properly
		GROUP BY
		cat.EnglishProductCategoryName -- column aliases aren't allowed
		,sub.EnglishProductSubcategoryName
		ORDER BY
		cat.EnglishProductCategoryName
		,sub.EnglishProductSubcategoryName

		-- filter to 2013 with WHERE
		SELECT
		YEAR(s.OrderDate) 'Year'
		,cat.EnglishProductCategoryName 'Category'
		,sub.EnglishProductSubcategoryName 'SubCategory'
		,count(1) 'Count' -- use 1 instead of a field for faster performance
		,sum(s.SalesAmount) 'Sales'
		,avg(s.SalesAmount) 'Avg_Quantity'
		,min(s.SalesAmount) 'Min_SaleAmount'
		,max(s.SalesAmount) 'Max_SaleAmount'

		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		INNER JOIN DimProductSubcategory sub ON p.ProductSubcategoryKey = sub.ProductSubcategoryKey
		INNER JOIN DimProductCategory cat ON sub.ProductCategoryKey = cat.ProductCategoryKey
		-- filter
		WHERE YEAR(s.OrderDate) = 2013 --use date function to parse year
		-- must use group by in order for aggregation to work properly
		GROUP BY
		YEAR(s.OrderDate)
		,cat.EnglishProductCategoryName -- column aliases aren't allowed
		,sub.EnglishProductSubcategoryName
		ORDER BY
		cat.EnglishProductCategoryName
		,sub.EnglishProductSubcategoryName

		-- Only show products in 2013 that sold more than $1M USD
		SELECT
		cat.EnglishProductCategoryName 'Category'
		,sub.EnglishProductSubcategoryName 'SubCategory'
		,count(1) 'Count' -- use 1 instead of a field for faster performance
		,sum(s.SalesAmount) 'Sales'
		,avg(s.SalesAmount) 'Avg_Quantity'
		,min(s.SalesAmount) 'Min_SaleAmount'
		,max(s.SalesAmount) 'Max_SaleAmount'
		FROM FactInternetSales s
		INNER JOIN DimProduct p ON s.ProductKey = p.ProductKey
		INNER JOIN DimProductSubcategory sub ON p.ProductSubcategoryKey = sub.ProductSubcategoryKey
		INNER JOIN DimProductCategory cat ON sub.ProductCategoryKey = cat.ProductCategoryKey
		-- filter
		WHERE YEAR(s.OrderDate) = 2013 --use date function to parse year
		-- must use group by in order for aggregation to work properly
		GROUP BY
		cat.EnglishProductCategoryName -- column aliases aren't allowed
		,sub.EnglishProductSubcategoryName
		-- use HAVING to filter after the aggregate is computed
		HAVING
		sum(s.SalesAmount) > 1000000
		ORDER BY
		cat.EnglishProductCategoryName
		,sub.EnglishProductSubcategoryName
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,46 @@
		use AdventureWorksDW2014;

		-- Sub Queries

		-- Use a sub-query to aggregate an underlying Table
		select *
		from (
		select sum(SalesAmount) as 'Sales', YEAR(OrderDate) as 'Yr'
		from FactInternetSales
		group by YEAR(OrderDate)
		) YrSales

		-- Create new aggregates on to of derived
		select avg(Sales) as 'AvgSales'
		from (
		select sum(SalesAmount) as 'Sales', YEAR(OrderDate) as 'Yr'
		from FactInternetSales
		group by YEAR(OrderDate)
		) YrSales

		-- Use a subquery to test if values are IN another table
		SELECT EnglishProductName 'Product'
		FROM DimProduct p
		WHERE p.ProductSubcategoryKey IN
		(SELECT sc.ProductSubcategoryKey
		FROM DimProductSubcategory sc
		WHERE sc.EnglishProductSubcategoryName = 'Wheels')

		-- Re-write this as a Join instead
		SELECTp.EnglishProductName
		FROMDimProduct p
		JOINDimProductSubcategory sc ON p.ProductSubcategoryKey = sc.ProductSubcategoryKey
		WHEREsc.EnglishProductSubcategoryName = 'Wheels'

		-- Use EXISTS to test if the outer queries value is present in the sub-query
		-- Somtimes this is the only way to express this join type
		SELECT EnglishProductName 'Product'
		FROM DimProduct p
		WHERE EXISTS
		(SELECT * -- no data is returned, only a boolean true/false
		FROM DimProductSubcategory sc
		WHEREp.ProductSubcategoryKey = sc.ProductSubcategoryKey
		ANDsc.EnglishProductSubcategoryName = 'Wheels')