All the following questions deal with the adventureworksLT$2019$ DB and the tables have been provided

Show the CompanyName for all customers with an address in City 'Dallas' $[$Customer$,$ CustomerAddress, Address$]$

How many items with ListPrice more than $$1000$ have been sold $[$SalesOrderDetail$,$ Product$]$

Give the CompanyName of those customers with orders over $$100000.$ Include the subtotal plus tax plus freight. $[$SalesOrderHeader$,$ Customer$]$

Find the number of left racing socks $(\text{'}$Racing Socks, L$\text{'})$ ordered by CompanyName 'Riding Cycles' $[$SalesOrderDetail$,$ Product, SalesOrderHeader,Customer$]$

A "Single Item Order" is a customer order where only one item is ordered. Show the SalesOrderID and the UnitPrice for every Single Item Order. $[$SalesOrderDetail$]$

Where did the racing socks go$?$ List the product name and the CompanyName for all Customers who ordered ProductModel 'Racing Socks'. $[$ProductModel$,$ Product,SalesOrderDetail,SalesOrderHeader, Customer$]$

Show the product description for culture $\text{'}$fr$\text{'}$ for product with ProductID $736.$

$[$ProductDescription$,$ ProductModelProductDescription,ProductModel,Product$]$

Use the SubTotal value in SaleOrderHeader to list orders from the largest to the smallest. For each order show the CompanyName and the SubTotal and the total weight of the order. $[$Product$,$ SalesOrderDetail, SalesOrderHeader, Customer$]$

How many products in ProductCategory 'Cranksets' have been sold to an address in 'London'? $[$ProductCategory$,$ Product, SalesOrderDetail, SalesOrderHeader, Address$]$

List the ProductName and the quantity of what was ordered by 'Futuristic Bikes'

$[$Customer$,$ SalesOrderHeader, SalesOrderDetail, Product$]$