SQL queries help

1. Write a nested loop to print the hierarchy of product categories. Print a category and all its subcategories. Format should be like:

2. Write a query to display the list price as a text comment based on the price range for a product as follows

ListPrice = 0 THEN item - not for resale'

ListPrice

ListPrice >= 50 and ListPrice

ListPrice >= 250 and ListPrice AdventureWorksLT Schema SalesLT Schema Best Print Results if 8.5x11 paper, Landscape Fit to 1 sheet Dbo Schema PK ProductID U1 Name U2 ProductNumber U1 Name U2 rowguid ModifiedDate PK ErrorloglD Database Version VersionDate ModifiedDate ErrorNumber CustomerAddress FK2 ProductCategorylD SellStartDate PK,FK2 CustomerlD PK,FK1 AddressID U1 Name Errorline U2 rowguid AddressType rowguid ModifiedDate ModifiedDate U1 U3 rowguid PK SalesOrderlD PK,FK2 ProductModellD PK |Culture U1 RevisionNumber DueDate 1 AddressLine1 11 City 1 PostalCode U1 rowguid PK CustomerlD U2 SalesOrderNumber NameStyle Title FirstName MiddleName LastName FK1,11 CustomerlD ModifiedDate PK ShipMethod PK,FK1 SalesOrderlD PK SubTotal TaxAmt Freight TotalDue U1 rowguid Modified Date 1 EmailAddress FK2,11ProductID PasswordHashh Password Salt Key I Index U Unique Index U1 rowguid ModifiedDate LineTotal rowguid ModifiedDate U1 rowguid U1 FK2 ShipToAddressID FK3BilIToAddresSID +Computed Colum PK Pimary Key FK Foreign Key ModifiedDate