35. From the product_price table, write an SQL query to find the total and average market price for each currency where the average market price is greater than 100, and the currency is in INR or AUD....

Sql query

Extracted text: 35. From the product_price table, write an SQL query to find the total and average market price for each currency where the average market price is greater than 100, and the currency is in INR or AUD. Sec_id Pro_date Mkt Price Currency Pricing factor 1 HCL205 2013-07-17 487.39 INR 1 2 HDFC305 2013-07-15 1187.15 INR 1 3 HUL109 2013-03-23 20 USD 100 4 ICIC201 2012-06-24 50 GBP 150 5 INC501 2011-01-10 15 SGD 50 6 INF409 2012-04-01 25 USD 100 7 Mar408 2009-07-05 1257.39 PKR 0.7 8 Ran208 2008-05-11 112 CHF 80 9 10 WIP309 TCS103 2007-09-08 114 AUD 90 2008-10-05 120 AUD 90