anchor.diff:  		        		<% }
   		        		%>
   		        </select>
  +		        </td><td>
   		        <select class="form-control" name="state" <%= disabled %>>
   		        	<option value="all">All States</option>
   					<option value="Alabama">Alabama</option>
  
positive.code: <t:header title="Sales Analytics" />
  <%
  
  class Item 
  {
  	private int id=0;
  	private String name=null;
  	private float amount_price=0f;
  	public int getId() {
  		return id;
  	}
  	public void setId(int id) {
  		this.id = id;
  	}
  	public String getName() {
  		return name;
  	}
  	public void setName(String name) {
  		this.name = name;
  	}
  	public float getAmount_price() {
  		return amount_price;
  	}
  	public void setAmount_price(float amount_price) {
  		this.amount_price = amount_price;
  	}
  }
  
  ArrayList<Item> p_list=new ArrayList<Item>();
  ArrayList<Item> s_list=new ArrayList<Item>();
  Item item=null;
  Connection conn=null;
  Statement stmt,stmt_2,stmt_3;
  ResultSet rs=null,rs_2=null,rs_3=null;
  
negative.code: 					" ORDER BY u.name ASC LIMIT 20"+
  					" OFFSET "+r_offset;
  					  
  		   SQL_21 ="SELECT u.id, u.name, SUM(s.quantity*s.price) AS amount"+
  					" FROM users u LEFT JOIN sales s ON s.uid = u.id"+
  					" WHERE u.age between " + age + " AND u.state='"+ state +"'" +
  					" GROUP BY u.name,u.id"+
  					" ORDER BY u.name ASC LIMIT 1"+
  					" OFFSET "+next_r_offset;
  		   SQL_3 ="SELECT s.pid, s.uid, SUM(s.quantity*s.price) AS amount"+
  					" FROM sales AS s"+
  					" WHERE s.uid IN"+
  					" (SELECT id FROM users WHERE age BETWEEN "+age+" AND state = '"+state+"' ORDER BY name ASC LIMIT 20 OFFSET "+r_offset+")"+
  					" AND s.pid IN (SELECT id FROM products ORDER BY name ASC LIMIT 10 OFFSET "+c_offset+")"+
  					" GROUP BY s.uid, s.pid";
  		}
  	}
  	
  