locked
SQL Query RRS feed

  • Question

  • HI ,  I have query on multiplication of rows with the following one. I want to multiply AH * Y and add in the existing table as P1 as row in the attribute_description column  , pls let me know how we can achieve this by using SQL and python language both 

    Commodity_Description Country_Name Market_Year Attribute_Description Value
    rice India 2015 AH 0.053
    rice India 2015 BS 0.068
    rice India 2015 DC 0.35
    rice India 2015 ES 0.056
    rice India 2015 Exports 0.063
    rice India 2015 FDC 0.225
    rice India 2015 FSIC 0.125
    rice India 2015 Imports 0.001
    rice India 2015 Production 0.4
    rice India 2015 TD 0.469
    rice India 2015 TS 0.469
    rice India 2015 Y 7.55
    Corn Australia 2016 AH 0.068
    Corn Australia 2016 BS 0.056
    Corn Australia 2016 DC 0.355
    Corn Australia 2016 ES 0.071
    Corn Australia 2016 Exports 0.068
    Corn Australia 2016 FDC 0.23
    Corn Australia 2016 FSIC 0.125
    Corn Australia 2016 Imports 0.002
    Corn Australia 2016 Production 0.436
    Corn Australia 2016 TD 0.494
    Corn Australia 2016 TS 0.494
    Corn Australia 2016 Y 6.41


    Saturday, July 4, 2020 3:29 PM

Answers

  • Your question doesn't belong in this forum about the Small Basic programming language.

    Please try a forum on Python


    Jan [ WhTurner ] The Netherlands

    Saturday, July 4, 2020 4:04 PM
    Answerer