-- 사과 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('사과', 2066, 8852139, 3823247, 5028892, 56.8, false);

-- 감귤 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('감귤', 2557, 5196222, 1903310, 3292913, 63.4, false);

-- 수박 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('수박', 4447, 4523275, 2273084, 2250191, 49.7, false);

-- 배 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('배', 2448, 7265401, 3641190, 3624211, 49.9, false);

-- 포도 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('포도', 1545, 10642010, 4213986, 6428025, 60.4, false);

-- 양파 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('양파', 6787, 5077135, 2274485, 2802649, 55.2, false);

-- 대파 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('대파', 3769, 4352848, 1770456, 2582392, 59.3, false);

-- 오이 (시설)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('오이', 9974, 22729042, 12018109, 10710933, 47.1, true);

-- 상추 (시설)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('상추', 3062, 11087540, 6119823, 4967717, 44.8, true);

-- 고구마 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('고구마', 1812, 4108604, 2023417, 2085187, 50.8, false);