For the following question, assume that an SQLite database has a table named Stock, with the following columns:

Column Name

Type

TradingSymbol

TEXT

CompanyName

TEXT

NumShares

INTEGER

PurchasePrice

REAL

SellingPrice

REAL

Write an SQL Select statement that will return the TradingSymbol column and the NumShares column only from the rows where SellingPrice is greater than the PurchasePrice, and NumShares is greater than $100.$ The results should be sorted by the NumShares column in ascending order.