SQL Query Display the trade id stock i and total price for the secondary market trade with the highest total price. Convert prices to U. S dollars
select tr. trade_id, tr. stock_id, round(tr. price_total * con. exchange_rate,2) as "US Dollars"
from stock_exchange se
join trade tr
on se. STOCK_EX_ID = tr. STOCK_EX_ID
join currency curr
on curr. CURRENCY_ID = se. currency_id
join conversion con
on con. from_CURRENCY_ID = curr. CURRENCY_ID
Where (tr. PRICE_TOTAL) = (Select Max(price_total) from trade) and curr. name = 'Dollar'
group by tr. trade_id, tr. stock_id, round(tr. price_total);
tried but i keep getting errors about it not being a group by function

Solution: the categorization of functional and non-functional requirement are as follows: some of the more typical functional requirements include: • business rules• transaction corrections, adjustments and cancellations• administrative functions• authentication• authorization levels• audit tracking• external interfaces• certification requirements• reporting requirements• historical data• legal or regulatory requirementswhile,some typical non-functional requirements are: • performance – for example response time, throughput, utilization, static volumetric• scalability• capacity• availability• reliability• recoverability• maintainability• serviceability• security• regulatory• manageability• environmental• data integrity• usability• interoperability

I’d say platform as a service (paas) or application platform as a service (apaas) or platform base service is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app.

Ihad the same question but i tested it out and it didn't work.