Computers and Technology, 15.08.2020 21:01, ayoismeisalex
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
Answers: 2
Computers and Technology, 23.06.2019 15:00, med69
Barbara is interested in pursuing a career in the science and math pathway. which qualifications will her reach that goal? a. an advanced knowledge of physics and math b. an advanced knowledge of engineering and math c. an advanced knowledge of physics and robotics an d. advanced knowledge of machinery and math
Answers: 2
Computers and Technology, 24.06.2019 11:00, airbenderjermai
Need fast im timed in a paragraph of 125 words, explain at least three ways that engineers explore possible solutions in their projects.
Answers: 2
Computers and Technology, 24.06.2019 12:30, tragicteekaay
Nikki sent flyers in the mail to all houses within the city limits promoting her computer repair service what type of promotion is this and example of
Answers: 1
SQL Query
Display the trade id stock i and total price for the secondary market trade with the high...
Mathematics, 14.07.2019 01:10
Mathematics, 14.07.2019 01:10
Mathematics, 14.07.2019 01:10
Mathematics, 14.07.2019 01:10