SHARE
TWEET

blurb

a guest Feb 18th, 2020 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2000-01-01'   and x3date <= '2000-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2001-01-01'   and x3date <= '2001-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2002-01-01'   and x3date <= '2002-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2003-01-01'   and x3date <= '2003-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2004-01-01'   and x3date <= '2004-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2005-01-01'   and x3date <= '2005-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2006-01-01'   and x3date <= '2006-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2007-01-01'   and x3date <= '2007-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2008-01-01'   and x3date <= '2008-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2009-01-01'   and x3date <= '2009-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2010-01-01'   and x3date <= '2010-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2011-01-01'   and x3date <= '2011-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2012-01-01'   and x3date <= '2012-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2013-01-01'   and x3date <= '2013-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2014-01-01'   and x3date <= '2014-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2015-01-01'   and x3date <= '2015-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2016-01-01'   and x3date <= '2016-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2017-01-01'   and x3date <= '2017-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2018-01-01'   and x3date <= '2018-12-31' and x4 like 'SW13 %' ;SELECT AVG(x2number) as price FROM landreg.t_master where x3date >= '2019-01-01'   and x3date <= '2019-12-31' and x4 like 'SW13 %' ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top