hotels.txt

INSERT INTO hotel VALUES ("HOT00000", "LOC00071", "Y", 2), ("HOT00001", "LOC00071", "Y", 2), ("HOT00002", "LOC00072", "N", 2), ("HOT00003", "LOC00073", "Y", 5), ("HOT00004", "LOC00071", "Y", 5), ("HOT00005", "LOC00074", "Y", 5), ("HOT00006", "LOC00071", "Y", 5), ("HOT00007", "LOC00072", "N", 1), ("HOT00008", "LOC00075", "Y", 5), ("HOT00009", "LOC00074", "N", 5), ("HOT00010", "LOC00074", "Y", 3), ("HOT00011", "LOC00076", "Y", 3), ("HOT00012", "LOC00077", "N", 3), ("HOT00013", "LOC00076", "N", 5), ("HOT00014", "LOC00078", "Y", 2), ("HOT00015", "LOC00074", "Y", 3), ("HOT00016", "LOC00072", "N", 2), ("HOT00017", "LOC00079", "Y", 2), ("HOT00018", "LOC00080", "Y", 2), ("HOT00019", "LOC00081", "Y", 1), ("HOT00020", "LOC00082", "N", 5), ("HOT00021", "LOC00083", "N", 3), ("HOT00022", "LOC00084", "N", 2), ("HOT00023", "LOC00083", "N", 5), ("HOT00024", "LOC00085", "N", 5), ("HOT00025", "LOC00086", "Y", 5), ("HOT00026", "LOC00087", "Y", 5), ("HOT00027", "LOC00083", "N", 2), ("HOT00028", "LOC00088", "Y", 2), ("HOT00029", "LOC00089", "N", 3), ("HOT00030", "LOC00083", "N", 5), ("HOT00031", "LOC00090", "N", 2), ("HOT00032", "LOC00086", "N", 4), ("HOT00033", "LOC00091", "N", 1), ("HOT00034", "LOC00092", "N", 3), ("HOT00035", "LOC00087", "N", 4), ("HOT00036", "LOC00083", "Y", 2), ("HOT00037", "LOC00083", "Y", 5), ("HOT00038", "LOC00083", "Y", 1), ("HOT00039", "LOC00083", "Y", 1), ("HOT00040", "LOC00083", "N", 1), ("HOT00041", "LOC00083", "Y", 3), ("HOT00042", "LOC00083", "Y", 2), ("HOT00043", "LOC00093", "N", 5), ("HOT00044", "LOC00094", "Y", 4), ("HOT00045", "LOC00095", "Y", 2), ("HOT00046", "LOC00096", "N", 1), ("HOT00047", "LOC00097", "Y", 2), ("HOT00048", "LOC00098", "N", 4), ("HOT00049", "LOC00099", "Y", 5), ("HOT00050", "LOC00100", "Y", 5), ("HOT00051", "LOC00097", "N", 2), ("HOT00052", "LOC00101", "N", 2), ("HOT00053", "LOC00098", "Y", 1), ("HOT00054", "LOC00101", "N", 4), ("HOT00055", "LOC00102", "Y", 4), ("HOT00056", "LOC00103", "N", 3), ("HOT00057", "LOC00098", "N", 4), ("HOT00058", "LOC00104", "Y", 5), ("HOT00059", "LOC00105", "N", 2), ("HOT00060", "LOC00106", "N", 4), ("HOT00061", "LOC00107", "Y", 5), ("HOT00062", "LOC00108", "N", 1), ("HOT00063", "LOC00093", "N", 5), ("HOT00064", "LOC00109", "N", 4), ("HOT00065", "LOC00110", "N", 4), ("HOT00066", "LOC00111", "N", 3), ("HOT00067", "LOC00112", "Y", 1), ("HOT00068", "LOC00113", "Y", 3), ("HOT00069", "LOC00107", "N", 5), ("HOT00070", "LOC00114", "Y", 2), ("HOT00071", "LOC00115", "N", 4), ("HOT00072", "LOC00093", "Y", 3), ("HOT00073", "LOC00116", "Y", 1), ("HOT00074", "LOC00116", "Y", 5), ("HOT00075", "LOC00117", "N", 3), ("HOT00076", "LOC00118", "N", 5), ("HOT00077", "LOC00094", "N", 5), ("HOT00078", "LOC00119", "Y", 4), ("HOT00079", "LOC00116", "Y", 4), ("HOT00080", "LOC00096", "Y", 1), ("HOT00081", "LOC00120", "N", 5), ("HOT00082", "LOC00093", "N", 3), ("HOT00083", "LOC00110", "Y", 3), ("HOT00084", "LOC00121", "Y", 2), ("HOT00085", "LOC00122", "N", 2), ("HOT00086", "LOC00123", "Y", 2), ("HOT00087", "LOC00124", "N", 1), ("HOT00088", "LOC00125", "N", 2), ("HOT00089", "LOC00126", "N", 5), ("HOT00090", "LOC00127", "Y", 4), ("HOT00091", "LOC00126", "Y", 5), ("HOT00092", "LOC00121", "N", 2), ("HOT00093", "LOC00127", "Y", 1), ("HOT00094", "LOC00123", "Y", 3), ("HOT00095", "LOC00127", "Y", 5), ("HOT00096", "LOC00128", "N", 5), ("HOT00097", "LOC00129", "Y", 2), ("HOT00098", "LOC00130", "Y", 5), ("HOT00099", "LOC00131", "N", 5), ("HOT00100", "LOC00132", "Y", 1), ("HOT00101", "LOC00133", "Y", 2), ("HOT00102", "LOC00132", "Y", 4), ("HOT00103", "LOC00134", "N", 5), ("HOT00104", "LOC00135", "N", 1), ("HOT00105", "LOC00136", "Y", 1), ("HOT00106", "LOC00137", "N", 5), ("HOT00107", "LOC00138", "N", 2), ("HOT00108", "LOC00137", "N", 3), ("HOT00109", "LOC00139", "Y", 2), ("HOT00110", "LOC00140", "Y", 5), ("HOT00111", "LOC00136", "N", 3), ("HOT00112", "LOC00141", "N", 3), ("HOT00113", "LOC00141", "N", 3), ("HOT00114", "LOC00135", "Y", 3), ("HOT00115", "LOC00135", "Y", 5), ("HOT00116", "LOC00134", "N", 5), ("HOT00117", "LOC00142", "N", 3), ("HOT00118", "LOC00142", "Y", 2), ("HOT00119", "LOC00143", "N", 5), ("HOT00120", "LOC00144", "Y", 4), ("HOT00121", "LOC00145", "Y", 2), ("HOT00122", "LOC00146", "N", 5), ("HOT00123", "LOC00147", "Y", 2), ("HOT00124", "LOC00148", "Y", 5), ("HOT00125", "LOC00149", "N", 3), ("HOT00126", "LOC00147", "Y", 3), ("HOT00127", "LOC00150", "Y", 2), ("HOT00128", "LOC00151", "Y", 5), ("HOT00129", "LOC00152", "Y", 3), ("HOT00130", "LOC00153", "Y", 4), ("HOT00131", "LOC00154", "N", 3), ("HOT00132", "LOC00149", "Y", 3), ("HOT00133", "LOC00148", "N", 4), ("HOT00134", "LOC00147", "N", 5), ("HOT00135", "LOC00155", "Y", 1), ("HOT00136", "LOC00156", "Y", 1), ("HOT00137", "LOC00154", "Y", 3), ("HOT00138", "LOC00157", "N", 4), ("HOT00139", "LOC00154", "N", 3), ("HOT00140", "LOC00151", "Y", 5), ("HOT00141", "LOC00158", "N", 2), ("HOT00142", "LOC00151", "Y", 5), ("HOT00143", "LOC00159", "N", 5), ("HOT00144", "LOC00144", "N", 1), ("HOT00145", "LOC00160", "Y", 5), ("HOT00146", "LOC00151", "N", 1), ("HOT00147", "LOC00159", "Y", 1), ("HOT00148", "LOC00161", "N", 1), ("HOT00149", "LOC00147", "N", 5), ("HOT00150", "LOC00162", "N", 1), ("HOT00151", "LOC00147", "N", 1), ("HOT00152", "LOC00144", "Y", 4), ("HOT00153", "LOC00163", "N", 2), ("HOT00154", "LOC00164", "N", 3), ("HOT00155", "LOC00165", "N", 2), ("HOT00156", "LOC00164", "N", 3), ("HOT00157", "LOC00166", "Y", 5), ("HOT00158", "LOC00163", "N", 3), ("HOT00159", "LOC00165", "Y", 1), ("HOT00160", "LOC00167", "N", 4), ("HOT00161", "LOC00164", "N", 4), ("HOT00162", "LOC00167", "Y", 3), ("HOT00163", "LOC00168", "Y", 4), ("HOT00164", "LOC00169", "N", 5), ("HOT00165", "LOC00170", "Y", 3), ("HOT00166", "LOC00171", "Y", 4), ("HOT00167", "LOC00172", "Y", 1), ("HOT00168", "LOC00173", "Y", 4), ("HOT00169", "LOC00173", "N", 5), ("HOT00170", "LOC00174", "Y", 4), ("HOT00171", "LOC00173", "N", 5), ("HOT00172", "LOC00175", "N", 4), ("HOT00173", "LOC00176", "Y", 4), ("HOT00174", "LOC00169", "N", 2), ("HOT00175", "LOC00177", "Y", 5), ("HOT00176", "LOC00178", "N", 3), ("HOT00177", "LOC00176", "Y", 3), ("HOT00178", "LOC00172", "Y", 5), ("HOT00179", "LOC00179", "N", 2), ("HOT00180", "LOC00180", "N", 4), ("HOT00181", "LOC00169", "N", 4), ("HOT00182", "LOC00181", "Y", 5), ("HOT00183", "LOC00182", "Y", 3), ("HOT00184", "LOC00183", "Y", 5), ("HOT00185", "LOC00184", "N", 1), ("HOT00186", "LOC00185", "N", 3), ("HOT00187", "LOC00186", "Y", 4), ("HOT00188", "LOC00185", "N", 4), ("HOT00189", "LOC00182", "N", 2), ("HOT00190", "LOC00182", "N", 2), ("HOT00191", "LOC00187", "N", 2), ("HOT00192", "LOC00188", "N", 4), ("HOT00193", "LOC00189", "N", 3), ("HOT00194", "LOC00190", "N", 1), ("HOT00195", "LOC00183", "N", 3), ("HOT00196", "LOC00191", "Y", 5), ("HOT00197", "LOC00190", "N", 1), ("HOT00198", "LOC00186", "Y", 3), ("HOT00199", "LOC00192", "Y", 3), ("HOT00200", "LOC00193", "Y", 4), ("HOT00201", "LOC00192", "Y", 5), ("HOT00202", "LOC00194", "N", 3), ("HOT00203", "LOC00195", "N", 5), ("HOT00204", "LOC00193", "N", 2)