Tables and Attributes in db$\_$pvfc$12\_$big $($Note: Attributes in Teradata SQL are not case sensitive$.)$

$$

CUSTOMER$\_$TABLE

$$ Customerid

$$ Customername

$$ Customeraddress

$$ Customercity

$$ Customerstate

$$ Customerpostalcode

$$

PRODUCT$\_$TABLE

$$ Productid

$$ Productdescription

$$ Productfinish

$$ Productstandardprice

$$ Productonhand

$$ Productlineid

$$

PRODUCEDIN$\_$TABLE

$$ Productid

$$ Workcenterid

$$

PRODUCTLINE$\_$TABLE

$$ ProductLineid

$$ ProductLineName

$$

RAWMATERIAL$\_$TABLE

$$ Materialid

$$ Materialname

$$ Thickness

$$ Width

$$ Size

$$ Material

$$ Materialstandardprice

$$ Unitofmeasure

$$ Materialtype

$$

ORDER$\_$TABLE

$$ Orderid

$$ Orderdate

$$ Customerid

$$ Fulfillmentdate

$$ Salespersonid

$$ Shipadrsid

$$

ORDERLINE$\_$TABLE

$$ Orderlineid

$$ Orderid

$$ Productid

$$ Orderedquantity

$$

USES$\_$TABLE

$$ Productid

$$ Materialid

$$ Quantityrequired

$$

SUPPLIES$\_$TABLE

$$ Vendorid

$$ Materialid

$$ Supplyunitprice

$$

TERRITORY$\_$TABLE

$$ TerritoryID $($PK$)$

$$ TerritoryName

$$

SALESPERSON$\_$TABLE

$$ SalespersonID $($PK$)$

$$ SalespersonName

$$ SalespersonAddress

SalesTerritoryID $($the same domain of values as TerritoryID in the TERRITORY$\_$T table.$)$

$$

DOESBUSINESSIN$\_$TABLE

$$ TerritoryID

$$ CustomerID

$$

WORKSIN$\_$TABLE

$$ EmployeeID

$$ WorkcenterID

$$

WORKCENTER$\_$TABLE

$$ WorkcenterID $($PK$)$

$$ Workcenterlocation

$$

EMPLOYEE$\_$TABLE

$$ EmployeeID $($PK$)$

$$ EmployeeName

$$ EmployeeAddress

$$ EmployeeCity

$$ EmployeeState

$$ EmployeeZip

$$ EmployeeDateHired

$$ EmployeeBirthDate

In the RawMaterial table, which are the widest raw materials $($identified by the Materialid column$)$ made of Ash $($Material column$)$ that are between $20$ and $50$ units thick?

$$

Which products use the widest raw materials made of Ash that are between $20$ and $50$ units thick? $($Hint: This query builds on the query in the previous question.$)$