Hi there, needs some help for this C# review question
Question 5. Assume a database has a table name Stock with the following data Trading_Symbol SU 01 AB 02 SU_03 AB_04 Company Name Alison Bravo Alpha Gold Num_Shares 100,000 125,000 325,000 50,250 Purchase_Price 50.75 49.45 24.48 55.99 Selling Price 80.55 10.00 82.88 25.00 a. Write a SQL select statement that returns the Trading_Symbol column only from the rows where the Purchase_Price is greater than or equal to $25.00 b. Write a SQL select statement that returns the Trading Symbol and Num_Shares where the Trading Symbol starts with “SU”. c. Write a SQL select statement that returns the Trading_Symbol column and the Num_Shares from the rows where Selling Price is greater than Purchase_Price anad Num_Shares is greater than 150,000. The results should be sorted by Num_Shares in descending order. d. Write a Select that returns the average price of the purchase price. Page 4 of 5 Show transcribed image text Question 5. Assume a database has a table name Stock with the following data Trading_Symbol SU 01 AB 02 SU_03 AB_04 Company Name Alison Bravo Alpha Gold Num_Shares 100,000 125,000 325,000 50,250 Purchase_Price 50.75 49.45 24.48 55.99 Selling Price 80.55 10.00 82.88 25.00 a. Write a SQL select statement that returns the Trading_Symbol column only from the rows where the Purchase_Price is greater than or equal to $25.00 b. Write a SQL select statement that returns the Trading Symbol and Num_Shares where the Trading Symbol starts with “SU”. c. Write a SQL select statement that returns the Trading_Symbol column and the Num_Shares from the rows where Selling Price is greater than Purchase_Price anad Num_Shares is greater than 150,000. The results should be sorted by Num_Shares in descending order. d. Write a Select that returns the average price of the purchase price. Page 4 of 5
Expert Answer
Answer to Question 5. Assume a database has a table name Stock with the following data Trading_Symbol SU 01 AB 02 SU_03 AB_04 Comp…