#include <iostream>
#include <vector>
using namespace std;
int main(){
  int q;
  cin >> q;
  cout << "CREATE INDEX idx1 ON point(x);" << endl;
  cout << "CREATE INDEX idx2 ON point(x,y);" << endl;
  while(q--){
    int a,b,c,d;
    cin >> a >> b >> c >> d;
    cout << "SELECT count(*) FROM point WHERE (x BETWEEN " << a 
    <<" and " << b << ") and (y BETWEEN " << c << " and " << d <<");" << endl;
  }
  return 0;
}