Display value from previous month SQL
<p><a href="https://i.stack.imgur.com/gdOXh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gdOXh.png" alt="enter image description here"></a></p>

<p>Hi,
I have columns as above. How to create select that in column "prev value" will display "value" from previous reporting date (previous month)?</p>

<pre><code>select id, name, name2, value, 
(
select value from bi_date as b2 
where b1.month(reporting_date) = (b2.month(reporting_date)-1)
) as prev_value

from table1 as b1
</code></pre>