{"id":2206,"date":"2026-04-06T15:39:30","date_gmt":"2026-04-06T03:39:30","guid":{"rendered":"https:\/\/nzwonderland.com\/?p=2206"},"modified":"2026-04-06T15:39:35","modified_gmt":"2026-04-06T03:39:35","slug":"sql-case-when-conditional-transformation-guide","status":"publish","type":"post","link":"https:\/\/nzwonderland.com\/en\/sql-case-when-conditional-transformation-guide\/","title":{"rendered":"SQL CASE WHEN Utilization The Magic of Turning Messy Row Data into Business Insights"},"content":{"rendered":"<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_9f6d99-40, .wp-block-kadence-advancedheading.kt-adv-heading2206_9f6d99-40[data-kb-block=\"kb-adv-heading2206_9f6d99-40\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_9f6d99-40 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_9f6d99-40[data-kb-block=\"kb-adv-heading2206_9f6d99-40\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_9f6d99-40 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_9f6d99-40[data-kb-block=\"kb-adv-heading2206_9f6d99-40\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_9f6d99-40 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_9f6d99-40\">\ub370\uc774\ud130 \ubd84\uc11d\ud558\uba74\uc11c \uc870\uac74\ubd80 \ubcc0\ud658\uc744 \ubc18\ub4dc\uc2dc \ub9cc\ub098\uac8c \ub429\ub2c8\ub2e4. \uc774\ub54c\uc5d0\ub294 SQL CASE WHEN\uc744 \ud65c\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \uc218\uce58\ud615 \ub370\uc774\ud130\ub97c \ubc94\uc8fc\ud615\uc73c\ub85c \ubc14\uafb8\ub294 \ube44\ub2dd(Binning) \uae30\uc220\ubd80\ud130, CTE(WITH\uc808)\ub97c \uccb4\uc778\ucc98\ub7fc \uc5f0\uacb0\ud574 \ubcf5\uc7a1\ud55c \ub85c\uc9c1\uc744 \uae54\ub054\ud558\uac8c \uc815\ub9ac\ud558\ub294 \uc2e4\ubb34 \ub178\ud558\uc6b0\uae4c\uc9c0 \ud55c \ubc88\uc5d0 \uc815\ub9ac\ud574 \ub4dc\ub9bd\ub2c8\ub2e4<\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_63f04f-7e, .wp-block-kadence-advancedheading.kt-adv-heading2206_63f04f-7e[data-kb-block=\"kb-adv-heading2206_63f04f-7e\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_63f04f-7e mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_63f04f-7e[data-kb-block=\"kb-adv-heading2206_63f04f-7e\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_63f04f-7e img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_63f04f-7e[data-kb-block=\"kb-adv-heading2206_63f04f-7e\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_63f04f-7e wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_63f04f-7e\"><strong>[\ud83d\ude80 SQL CASE WHEN &amp; \uc870\uac74\ubd80 \ubcc0\ud658 \ud575\uc2ec \uac00\uc774\ub4dc \uc694\uc57d]<\/strong><\/p>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<ul style=\"background-color:#f3efbf\" class=\"wp-block-list has-background\">\n<li><strong>\ud575\uc2ec \uac1c\ub150:<\/strong> <code>CASE WHEN<\/code>\uc740 \ud589\ubcc4 \uc870\uac74\uc744 \ud3c9\uac00\ud574 \uc0c8\ub85c\uc6b4 \uce74\ud14c\uace0\ub9ac\ub97c \ub9cc\ub4dc\ub294 &#8216;\ube44\ub2dd(Binning)&#8217;\uc758 \ud575\uc2ec \ub3c4\uad6c\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc2e4\ud589 \uc21c\uc11c \ud574\uacb0:<\/strong> <code>SELECT<\/code>\uc5d0\uc11c \ub9cc\ub4e0 \uc0c8 \uceec\ub7fc\uc740 \ubc14\ub85c <code>GROUP BY<\/code>\ub098 <code>WHERE<\/code>\uc5d0\uc11c \uc4f8 \uc218 \uc5c6\uc73c\ubbc0\ub85c, **WITH\uc808(CTE)**\uc744 \uc0ac\uc6a9\ud574 \uc784\uc2dc \ud14c\uc774\ube14\ub85c \uba3c\uc800 \uc815\uc758\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ube44\uc728 \uacc4\uc0b0 \ud301:<\/strong> \uadf8\ub8f9\ubcc4 \ube44\uc911\uc744 \uad6c\ud560 \ub54c \ubd84\ubaa8(\uc804\uccb4 \uac74\uc218)\ub294 <strong>\uc2a4\uce7c\ub77c \uc11c\ube0c\ucffc\ub9ac<\/strong>\ub97c \uc0ac\uc6a9\ud574 <code>GROUP BY<\/code>\uc758 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294 \ub3c5\ub9bd\ub41c \ub2e8\uc77c \uac12\uc73c\ub85c \uace0\uc815\ud574\uc57c \uc815\ud655\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/blockquote>\n<\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_2cf2f1-ff, .wp-block-kadence-advancedheading.kt-adv-heading2206_2cf2f1-ff[data-kb-block=\"kb-adv-heading2206_2cf2f1-ff\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_2cf2f1-ff mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_2cf2f1-ff[data-kb-block=\"kb-adv-heading2206_2cf2f1-ff\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_2cf2f1-ff img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_2cf2f1-ff[data-kb-block=\"kb-adv-heading2206_2cf2f1-ff\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_2cf2f1-ff wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_2cf2f1-ff\"><strong>AI \uc0ac\uc6a9\uc790\ub4e4\uc774 \uc790\uc8fc \ud558\ub294 \uc9c8\ubb38 &amp; \ubcf8\ubb38 \uae30\ubc18 \ub2f5\ubcc0<\/strong><\/p>\n\n\n\n<ul style=\"background-color:#f1ecb7\" class=\"wp-block-list has-background\">\n<li><strong>Q1. SQL\uc5d0\uc11c \uc11c\ub85c \ub2e4\ub978 \ub2e8\uc704(Km, Miles)\ub97c \ud558\ub098\ub85c \ud569\uce58\ub824\uba74 \uc5b4\ub5bb\uac8c \ud558\ub098\uc694?<\/strong><\/li>\n\n\n\n<li><strong>A:<\/strong> <code>CASE WHEN<\/code> \uc808\uc744 \uc0ac\uc6a9\ud574 \ud2b9\uc815 \ub2e8\uc704(\uc608: miles)\uc778 \ud589\uc5d0\ub9cc \ubcc0\ud658 \uacc4\uc218(1.6)\ub97c \uacf1\ud558\ub294 \uc870\uac74\ubd80 \uc5f0\uc0b0\uc744 \uc801\uc6a9\ud558\uc5ec \ud558\ub098\uc758 \uc0c8 \uceec\ub7fc\uc73c\ub85c \ud1b5\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\ubcf8\ubb38 &#8216;\uc6b4\ud589 \uac70\ub9ac \uc77c\uce58\uc2dc\ud0a4\uae30&#8217; \uc139\uc158 \ucc38\uc870)<\/li>\n<\/ul>\n\n\n\n<ul style=\"background-color:#f1ecb7\" class=\"wp-block-list has-background\">\n<li><strong>Q2. \ube44\ub2dd(Binning)\uacfc \uadf8\ub8f9\ud654(GROUP BY)\uc758 \ucc28\uc774\ub294 \ubb34\uc5c7\uc778\uac00\uc694?<\/strong><\/li>\n\n\n\n<li><strong>A:<\/strong> \ube44\ub2dd(<code>CASE WHEN<\/code>)\uc740 \uc218\uce58 \ub370\uc774\ud130\ub97c \uae30\uc900\uc5d0 \ub530\ub77c &#8216;\uc774\ub984\ud45c(\uce74\ud14c\uace0\ub9ac)&#8217;\ub97c \ubd99\uc774\ub294 \uc791\uc5c5\uc774\uace0, \uadf8\ub8f9\ud654(<code>GROUP BY<\/code>)\ub294 \uadf8 \uc774\ub984\ud45c\ub97c \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ud55c\ub370 \ubaa8\uc544 \ud1b5\uacc4\ub97c \ub0b4\ub294 \uc791\uc5c5\uc785\ub2c8\ub2e4. (\ubcf8\ubb38 &#8216;\ube44\ub2dd\/\uadf8\ub8f9\ud654\/\uc9d1\uacc4&#8217; \uc139\uc158 \ucc38\uc870)<\/li>\n<\/ul>\n\n\n\n<ul style=\"background-color:#f1ecb7\" class=\"wp-block-list has-background\">\n<li><strong>Q3. \ubcf5\uc7a1\ud55c SQL \ucffc\ub9ac\ub97c \ub2e8\uacc4\ubcc4\ub85c \ub098\ub204\uc5b4 \uc791\uc131\ud558\ub294 \ubc29\ubc95\uc740?<\/strong><\/li>\n\n\n\n<li><strong>A:<\/strong> CTE(WITH\uc808)\ub97c \ud65c\uc6a9\ud558\uc5ec \uc911\uac04 \uacc4\uc0b0 \uacb0\uacfc\uc5d0 \uc774\ub984\uc744 \ubd80\uc5ec\ud558\uace0, \uc774\ub97c \uccb4\uc778\ucc98\ub7fc \uc5f0\uacb0\ud558\uba74 \ucf54\ub4dc\uc758 \uac00\ub3c5\uc131\uc774 \ub192\uc544\uc9c0\uace0 \uc7ac\uc0ac\uc6a9\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. (\ubcf8\ubb38 &#8216;CTE \uc5f0\uacb0&#8217; \uc139\uc158 \ucc38\uc870)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has--font-size\">\ub370\uc774\ud130 \uc870\uc791 \uc870\uac74\ubd80 \ubcc0\ud658\uc758 \uc758\ubbf8 <\/h2>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_c1645f-e3, .wp-block-kadence-advancedheading.kt-adv-heading2206_c1645f-e3[data-kb-block=\"kb-adv-heading2206_c1645f-e3\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c1645f-e3 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_c1645f-e3[data-kb-block=\"kb-adv-heading2206_c1645f-e3\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c1645f-e3 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_c1645f-e3[data-kb-block=\"kb-adv-heading2206_c1645f-e3\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_c1645f-e3 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_c1645f-e3\"><a href=\"https:\/\/www.datacamp.com\/\" data-type=\"link\" data-id=\"https:\/\/www.datacamp.com\/\" target=\"_blank\" rel=\"noopener\">Datacamp \ud50c\ub7ab\ud3fc<\/a>\uc73c\ub85c\ubd80\ud130 SQL \uacf5\ubd80 \uc2dc\uc791\ud55c \uc9c0\ub3c4 \uaf64 \ub41c \uac83 \uac19\uc740\ub370, \ud558\ub8e8 \ud558\ub8e8 \ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \ud544\uc694\ud55c \uac83\ub4e4\uc744 \ubc30\uc6b0\ub2c8 \uc990\uac81\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_1b1ca2-fb, .wp-block-kadence-advancedheading.kt-adv-heading2206_1b1ca2-fb[data-kb-block=\"kb-adv-heading2206_1b1ca2-fb\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_1b1ca2-fb mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_1b1ca2-fb[data-kb-block=\"kb-adv-heading2206_1b1ca2-fb\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_1b1ca2-fb img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_1b1ca2-fb[data-kb-block=\"kb-adv-heading2206_1b1ca2-fb\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_1b1ca2-fb wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_1b1ca2-fb\">\uc624\ub298\uc740 \ub370\uc774\ud130 \uc870\uc791 \uc870\uac74\ubd80 \ubcc0\ud658\uc5d0 \ub300\ud574\uc11c \uc598\uae30\ud574 \ubcf4\uc790. \ub370\uc774\ud130 \ubd84\uc11d\uc744 \ud558\ub2e4 \ubcf4\uba74, \ub370\uc774\ud130 \uac12 \uae30\uc900\uc73c\ub85c \uadf8\ub8f9\uc73c\ub85c \ubb36\uc5b4\uc57c \ud560 \ub54c\uac00 \uc788\ub2e4. \ub9d0\ubcf4\ub2e4 \uc608\uc2dc\uac00 \ud56d\uc0c1 \uc774\ud574\ud558\uae30\uac00 \uc27d\ub2e4. <\/p>\n\n\n<style>.kb-image2206_e030f0-6a .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_e030f0-6a img.kb-img, .kb-image2206_e030f0-6a .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_e030f0-6a\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"1006\" height=\"313\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image.jpg\" alt=\"SQL CASE WHEN \uc774\uc6a9\ud558\uae30 \uc704\ud55c \uc608\uc2dc\" class=\"kb-img wp-image-2207\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image.jpg 1006w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-300x93.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-768x239.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-18x6.jpg 18w\" sizes=\"(max-width: 1006px) 100vw, 1006px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_d880e3-4f, .wp-block-kadence-advancedheading.kt-adv-heading2206_d880e3-4f[data-kb-block=\"kb-adv-heading2206_d880e3-4f\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_d880e3-4f mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_d880e3-4f[data-kb-block=\"kb-adv-heading2206_d880e3-4f\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_d880e3-4f img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_d880e3-4f[data-kb-block=\"kb-adv-heading2206_d880e3-4f\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_d880e3-4f wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_d880e3-4f\">\uc704\uc758 \ub370\uc774\ud130\ub294 \ube44\ud589\uae30\uc640 \uc6b4\ud589 \uac70\ub9ac\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ub2f4\uace0 \uc788\ub2e4. distance_unit\uc740 \uadf8 \uc6b4\ud589 \uac70\ub9ac\uc5d0 \ub300\ud55c \ub2e8\uc704\uc774\ub2e4. <u1>\uadf8\ub7f0\ub370, \uc5b4\ub5a4 \uac83\uc740 Km \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uac83\uc740 miles\ub85c \ub418\uc5b4 \uc788\ub2e4.<\/u1> <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_59fd4e-c0, .wp-block-kadence-advancedheading.kt-adv-heading2206_59fd4e-c0[data-kb-block=\"kb-adv-heading2206_59fd4e-c0\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_59fd4e-c0 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_59fd4e-c0[data-kb-block=\"kb-adv-heading2206_59fd4e-c0\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_59fd4e-c0 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_59fd4e-c0[data-kb-block=\"kb-adv-heading2206_59fd4e-c0\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_59fd4e-c0 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_59fd4e-c0\">\uc608\ub97c \ub4e4\uc5b4, 7902.95km\uacfc 7844.42miles\ub294 \ube44\uc2b7\ud55c \uac12\uc744 \uac00\uc84c\uc9c0\ub9cc, \uc0ac\uc2e4 \uc5c4\uccad\ub09c \uac70\ub9ac \ucc28\uc774\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. 1 mile = \uc57d 1.61km\uc774\ub2e4. \ub9cc\uc57d miles\ub97c Km\uc73c\ub85c \ub2e8\uc704 \ubcc0\ud658\uc744 \ud558\uba74 \uc544\ub798\uc640 \uac19\ub2e4<\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_8ba181-9e, .wp-block-kadence-advancedheading.kt-adv-heading2206_8ba181-9e[data-kb-block=\"kb-adv-heading2206_8ba181-9e\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_8ba181-9e mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_8ba181-9e[data-kb-block=\"kb-adv-heading2206_8ba181-9e\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_8ba181-9e img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_8ba181-9e[data-kb-block=\"kb-adv-heading2206_8ba181-9e\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_8ba181-9e wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_8ba181-9e\">\uc774\ub807\uac8c \uc11c\ub85c \ub2e4\ub978 \ub2e8\uc704\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5f0\uc0b0\ud55c \ud6c4 \uc808\ub300\uac12\ub9cc \ubd24\uc744 \ub54c \ud63c\ub780\uc774 \uc62c \uc218 \uc788\ub2e4. \uadf8\ub798\uc11c \uc774\uac83\uc744 \uc77c\uce58 \uc2dc\ud0ac \ud544\uc694\uac00 \uc788\uc5b4 \ubcf4\uc774\uc9c0 \uc54a\ub098? <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_287f3d-f0, .wp-block-kadence-advancedheading.kt-adv-heading2206_287f3d-f0[data-kb-block=\"kb-adv-heading2206_287f3d-f0\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_287f3d-f0 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_287f3d-f0[data-kb-block=\"kb-adv-heading2206_287f3d-f0\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_287f3d-f0 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_287f3d-f0[data-kb-block=\"kb-adv-heading2206_287f3d-f0\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_287f3d-f0 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_287f3d-f0\"><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading has--font-size\">\uc65c \ub370\uc774\ud130 \uc870\uac74\ubd80 \ubcc0\ud658\uc774 \ud544\uc694\ud558\uc9c0?<\/h3>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_6f52cf-fe, .wp-block-kadence-advancedheading.kt-adv-heading2206_6f52cf-fe[data-kb-block=\"kb-adv-heading2206_6f52cf-fe\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_6f52cf-fe mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_6f52cf-fe[data-kb-block=\"kb-adv-heading2206_6f52cf-fe\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_6f52cf-fe img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_6f52cf-fe[data-kb-block=\"kb-adv-heading2206_6f52cf-fe\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_6f52cf-fe wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_6f52cf-fe\">\uac00\uacf5\ub418\uc9c0 \uc54a\uc740 \uc218\uc5c6\uc774 \ubc29\ub300\ud55c \uc591\uc758 \ub370\uc774\ud130\ub97c \uadf8\ub0e5 \ud55c\ubc88 \ubd10 \ubd10\ub77c. \ub3c4\ub300\uccb4 \ub370\uc774\ud130\uac00 \ubb34\uc2a8 \uc774\uc57c\uae30\ub97c \ud558\uace0 \uc788\ub294\uc9c0 \uc774\ud574\ud558\uae30\uac00 \uc5b4\ub835\ub2e4. <u1>\ub370\uc774\ud130 \uc870\uc791 \uc870\uac74\ubd80 \ubcc0\ud658\uc740 \uc774\ub7f0 \ubc29\ub300\ud55c \ub370\uc774\ud130 \uc18d\uc5d0\uc11c \ubcc0\ud658\uc744 \ud1b5\ud574\uc11c \uc778\uc0ac\uc774\ud2b8\ub97c \uac00\uc838\uc62c \uc218 \uc788\ub2e4.<\/u1> <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ube44\ub2dd :  \uc911\uad6c\ub09c\ubc29 \ub370\uc774\ud130\uc5d0 \uc870\uac74\uc744 \ubd99\uc774\uace0 \uadf8 \uc870\uac74\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uc5d0 \uc774\ub984\uc744 \ubd99\uc778\ub2e4 <\/li>\n\n\n\n<li>\uadf8\ub8f9\ud654 : \uadf8 \uc774\ub984\uc73c\ub85c \ubd88\ub9ac\ub294 \uac83\ub4e4\ub9cc \uadf8\ub8f9\ud654\ub97c \ud55c\ub2e4 <\/li>\n\n\n\n<li>\uc9d1\uacc4 : Count(), Sum(), AVerage() \uadf8\ub8f9\ub4e4\ub85c\ubd80\ud130 \uc778\uc0ac\uc774\ud2b8\ub97c \ubf51\ub294\ub2e4. <\/li>\n<\/ul>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_0ab08a-ec, .wp-block-kadence-advancedheading.kt-adv-heading2206_0ab08a-ec[data-kb-block=\"kb-adv-heading2206_0ab08a-ec\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_0ab08a-ec mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_0ab08a-ec[data-kb-block=\"kb-adv-heading2206_0ab08a-ec\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_0ab08a-ec img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_0ab08a-ec[data-kb-block=\"kb-adv-heading2206_0ab08a-ec\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_0ab08a-ec wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_0ab08a-ec\"><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading has--font-size\">SQL CASE WHEN \uc0ac\uc6a9 \ubc29\ubc95 <\/h3>\n\n\n\n<h4 class=\"wp-block-heading has--font-size\"><u1>1) \uc6b4\ud589 \uac70\ub9ac\ub97c \uc77c\uce58\uc2dc\ud0a4\uae30<\/u1> <\/h4>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_514205-94, .wp-block-kadence-advancedheading.kt-adv-heading2206_514205-94[data-kb-block=\"kb-adv-heading2206_514205-94\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_514205-94 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_514205-94[data-kb-block=\"kb-adv-heading2206_514205-94\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_514205-94 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_514205-94[data-kb-block=\"kb-adv-heading2206_514205-94\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_514205-94 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_514205-94\">\uc5b4\ub5bb\uac8c \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc744\uae4c? \uc77c\ub2e8 km\uc73c\ub85c \uc77c\uad00\uc801\uc73c\ub85c \uac00\uae30\ub85c \ud588\ub2e4. \uac01 \ud589\ub9c8\ub2e4 \uc5b4\ub5a4 \uac83\uc740 Km \ub2e8\uc704\ub85c, \uc5b4\ub5a4 \uac83\uc740 miles \ub2e8\uc704\ub85c \ub418\uc5b4 \uc788\uc744 \uac83\uc774\ub2e4. <\/p>\n\n\n<style>.kb-image2206_bcabc3-be .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_bcabc3-be img.kb-img, .kb-image2206_bcabc3-be .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_bcabc3-be\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-1.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"920\" height=\"310\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-1.jpg\" alt=\"SQL CASE WHEN \ub2e8\uc77c \uc870\uac74\" class=\"kb-img wp-image-2208\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-1.jpg 920w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-1-300x101.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-1-768x259.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-1-18x6.jpg 18w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_ceb551-b6, .wp-block-kadence-advancedheading.kt-adv-heading2206_ceb551-b6[data-kb-block=\"kb-adv-heading2206_ceb551-b6\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_ceb551-b6 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_ceb551-b6[data-kb-block=\"kb-adv-heading2206_ceb551-b6\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_ceb551-b6 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_ceb551-b6[data-kb-block=\"kb-adv-heading2206_ceb551-b6\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_ceb551-b6 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_ceb551-b6\">\ubc14\ub85c \ub370\uc774\ud130 \uc870\uc791 \uc870\uac74\ubd80 \ubcc0\ud658\uc740 \uc870\uac74\uc5d0 \ub530\ub77c \ub2e4\ub974\uac8c \uc801\uc6a9\uc2dc\ud0a4\ub294 \uac83\uc774\ub2e4. \uadf8 \uc870\uac74\ubd80 \ubcc0\ud658\uc744 \ud558\uac8c \ud574 \uc8fc\ub294 \uac83\uc774 SQL CASE WHEN\uc774\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_62d890-07, .wp-block-kadence-advancedheading.kt-adv-heading2206_62d890-07[data-kb-block=\"kb-adv-heading2206_62d890-07\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_62d890-07 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_62d890-07[data-kb-block=\"kb-adv-heading2206_62d890-07\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_62d890-07 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_62d890-07[data-kb-block=\"kb-adv-heading2206_62d890-07\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_62d890-07 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_62d890-07\">\ud06c\uac8c CASE, WHEN, END\ub85c \ub418\uc5b4 \uc788\ub2e4. \ub0b4\uac00 \uc704\uc758 CASE ~ END AS\uac00 \ubd80\ubd84\uc744 \uae00\ub85c \ud45c\ud604\ud574 \ubcf4\uaca0\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_b3d414-d7, .wp-block-kadence-advancedheading.kt-adv-heading2206_b3d414-d7[data-kb-block=\"kb-adv-heading2206_b3d414-d7\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_b3d414-d7 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_b3d414-d7[data-kb-block=\"kb-adv-heading2206_b3d414-d7\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_b3d414-d7 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_b3d414-d7[data-kb-block=\"kb-adv-heading2206_b3d414-d7\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_b3d414-d7 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_b3d414-d7\">distance_unit \uceec\ub7fc\uc758 \ub370\uc774\ud130 \uac12 \uc911\uc5d0 miles\uac00 \uc788\ub294 \ud589\uc740 distance \uceec\ub7fc \ub0b4 \ub370\uc774\ud130 \uac12\uc5d0 1.6\uc744 \uacf1\ud558\uace0, \ub9cc\uc57d miles\uac00 \uc544\ub2cc \uac83(ELSE)\uc740 distance \uceec\ub7fc \ub370\uc774\ud130 \uac12\uc744 \uc720\uc9c0\ud574\ub77c. \uadf8\ub9ac\uace0 \uadf8 \ub370\uc774\ud130 \uac12\ub4e4\uc744 \uc0c8 \uceec\ub7fc distance_km\uc758 \uac01 \ud589\uc5d0 \ub123\uc5b4\ub77c. <\/p>\n\n\n<style>.kb-image2206_4e447d-04 .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_4e447d-04 img.kb-img, .kb-image2206_4e447d-04 .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_4e447d-04\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-2.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"1020\" height=\"314\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-2.jpg\" alt=\"SQL CASE WHEN \ub2e8\uc77c \uc870\uac74\uc5d0 \ub300\ud55c \uacb0\uacfc \" class=\"kb-img wp-image-2211\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-2.jpg 1020w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-2-300x92.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-2-768x236.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-2-18x6.jpg 18w\" sizes=\"(max-width: 1020px) 100vw, 1020px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_907e35-8d, .wp-block-kadence-advancedheading.kt-adv-heading2206_907e35-8d[data-kb-block=\"kb-adv-heading2206_907e35-8d\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_907e35-8d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_907e35-8d[data-kb-block=\"kb-adv-heading2206_907e35-8d\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_907e35-8d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_907e35-8d[data-kb-block=\"kb-adv-heading2206_907e35-8d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_907e35-8d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_907e35-8d\">\ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uba74 \uc704\uc758 \uacb0\uacfc \uac12\uc774 \ub098\uc628\ub2e4. distance_km \uceec\ub7fc\uc774 \uc0c8\ub85c \uc0dd\uacbc\uace0, \uac01 \ud589\ub9c8\ub2e4 km\uc744 \ub2e8\uc704\ub85c \uc6b4\ud589 \uac70\ub9ac \uac12\uc744 \uac00\uc9c0\uac8c \ub418\uc5c8\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_f0572b-53, .wp-block-kadence-advancedheading.kt-adv-heading2206_f0572b-53[data-kb-block=\"kb-adv-heading2206_f0572b-53\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_f0572b-53 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_f0572b-53[data-kb-block=\"kb-adv-heading2206_f0572b-53\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_f0572b-53 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_f0572b-53[data-kb-block=\"kb-adv-heading2206_f0572b-53\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_f0572b-53 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_f0572b-53\"> <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_d1614e-a6, .wp-block-kadence-advancedheading.kt-adv-heading2206_d1614e-a6[data-kb-block=\"kb-adv-heading2206_d1614e-a6\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_d1614e-a6 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_d1614e-a6[data-kb-block=\"kb-adv-heading2206_d1614e-a6\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_d1614e-a6 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_d1614e-a6[data-kb-block=\"kb-adv-heading2206_d1614e-a6\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_d1614e-a6 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_d1614e-a6\"><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading has--font-size\"><u1>2) \ube44\ud589\uae30 \uc88c\uc11d \uc218\uc5d0 \ub530\ub77c \uc885\ub958\ub97c \ub098\ub220\ub77c<\/u1><\/h4>\n\n\n<style>.kb-image2206_f82b84-d3 .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_f82b84-d3 img.kb-img, .kb-image2206_f82b84-d3 .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_f82b84-d3\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-3.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"786\" height=\"310\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-3.jpg\" alt=\"SQL CASE WHEN \ub2e8\uc77c \uc870\uac741\" class=\"kb-img wp-image-2212\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-3.jpg 786w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-3-300x118.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-3-768x303.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-3-18x7.jpg 18w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_c68e93-b5, .wp-block-kadence-advancedheading.kt-adv-heading2206_c68e93-b5[data-kb-block=\"kb-adv-heading2206_c68e93-b5\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c68e93-b5 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_c68e93-b5[data-kb-block=\"kb-adv-heading2206_c68e93-b5\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c68e93-b5 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_c68e93-b5[data-kb-block=\"kb-adv-heading2206_c68e93-b5\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_c68e93-b5 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_c68e93-b5\">\ub0b4\uac00 \uc704\uc758 \ucf54\ub4dc\ub97c \ub9d0\ub85c \uc124\uba85\ud574 \ubcf4\uaca0\ub2e4 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>flights \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628\ub2e4 (\ud56d\uc0c1 FROM \ubd80\ud130 \uc77d\uc5b4\ub77c)<\/li>\n\n\n\n<li>flight_id, airline, total_seats, passengers \uceec\ub7fc\uc758 \ub370\uc774\ud130 \uac12\uc744 \uac00\uc838\uc640\ub77c (SELECT)<\/li>\n\n\n\n<li>\uac01 \ud589\uc5d0\uc11c total_seats\uc758 \uac12\uc774 300\ubcf4\ub2e4 \ud06c\uba74, Widebody, \uc544\ub2c8\uba74 Narrowbody\uc73c\ub85c \uadf8\uac83\uc744 aircraft_size \uc0c8 \uceec\ub7fc\uc758 \uac01 \ud589\ub9c8\ub2e4 \ub098\ud0c0\ub0b4\uc5b4\ub77c (CASE WHEN\uc808) <\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n<style>.kb-image2206_33b467-80 .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_33b467-80 img.kb-img, .kb-image2206_33b467-80 .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_33b467-80\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-4.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"965\" height=\"381\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-4.jpg\" alt=\"SQL CASE WHEN \ub2e8\uc77c \uc870\uac74\uc5d0 \uacb0\uacfc1\" class=\"kb-img wp-image-2213\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-4.jpg 965w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-4-300x118.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-4-768x303.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-4-18x7.jpg 18w\" sizes=\"(max-width: 965px) 100vw, 965px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_32dee8-ac, .wp-block-kadence-advancedheading.kt-adv-heading2206_32dee8-ac[data-kb-block=\"kb-adv-heading2206_32dee8-ac\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_32dee8-ac mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_32dee8-ac[data-kb-block=\"kb-adv-heading2206_32dee8-ac\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_32dee8-ac img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_32dee8-ac[data-kb-block=\"kb-adv-heading2206_32dee8-ac\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_32dee8-ac wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_32dee8-ac\">\ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uba74, \uc704\uc640 \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4. aircraft_size \uc0c8 \uceec\ub7fc\uc774 \ubcf4\uc778\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_04c26e-1b, .wp-block-kadence-advancedheading.kt-adv-heading2206_04c26e-1b[data-kb-block=\"kb-adv-heading2206_04c26e-1b\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_04c26e-1b mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_04c26e-1b[data-kb-block=\"kb-adv-heading2206_04c26e-1b\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_04c26e-1b img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_04c26e-1b[data-kb-block=\"kb-adv-heading2206_04c26e-1b\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_04c26e-1b wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_04c26e-1b\"><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading has--font-size\">3) SQL CASE WHEN, WITH\uc808, \uc2a4\uce7c\ub77c \ucffc\ub9ac \uc0ac\uc6a9 \ubc29\ubc95<\/h3>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_df0f31-9f, .wp-block-kadence-advancedheading.kt-adv-heading2206_df0f31-9f[data-kb-block=\"kb-adv-heading2206_df0f31-9f\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_df0f31-9f mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_df0f31-9f[data-kb-block=\"kb-adv-heading2206_df0f31-9f\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_df0f31-9f img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_df0f31-9f[data-kb-block=\"kb-adv-heading2206_df0f31-9f\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_df0f31-9f wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_df0f31-9f\">aircraft_size\ub294 \ud06c\uac8c 2\uac00\uc9c0 \uc885\ub958\ub2e4. Widebody\uc640 Narrowbody\uac00 \uac01\uac01 \uba87 \uac1c\uc778\uc9c0 \uce74\uc6b4\ud2b8\ud558\uace0, \uadf8 \uac1c\uc218\uac00 \uc804\uccb4\uc5d0\uc11c \uc5bc\ub9c8 \ub9cc\ud07c\uc778\uc9c0 \ube44\uc728\uc778 \uc9c0 \uc54c\uc544\ubcf4\uc790 <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_376353-a9, .wp-block-kadence-advancedheading.kt-adv-heading2206_376353-a9[data-kb-block=\"kb-adv-heading2206_376353-a9\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_376353-a9 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_376353-a9[data-kb-block=\"kb-adv-heading2206_376353-a9\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_376353-a9 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_376353-a9[data-kb-block=\"kb-adv-heading2206_376353-a9\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_376353-a9 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_376353-a9\">\uc77c\ub2e8 \uae30\ubcf8 \ub370\uc774\ud130\uc5d0\uc11c\ub294 aircraft_size\ub77c\ub294 \uceec\ub7fc\uc774 \uc5c6\ub2e4. \uc77c\ub2e8 \uadf8\uac83\ubd80\ud130 \uc2dc\uc791\uc744 \ud574\uc57c \ud55c\ub2e4. \uadf8\ub9ac\uace0 \uc870\uac74\uc5d0 \ub9cc\uc871\ud558\ub294 \ud589\uc774 \uba87 \uac1c\uc778\uc9c0 \uce74\uc6b4\ud2b8\ud558\ub294 \uac83\uc740 count() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_f69abe-8d, .wp-block-kadence-advancedheading.kt-adv-heading2206_f69abe-8d[data-kb-block=\"kb-adv-heading2206_f69abe-8d\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_f69abe-8d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_f69abe-8d[data-kb-block=\"kb-adv-heading2206_f69abe-8d\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_f69abe-8d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_f69abe-8d[data-kb-block=\"kb-adv-heading2206_f69abe-8d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_f69abe-8d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_f69abe-8d\">\uadf8\ub7f0\ub370, \uadf8 \uc870\uac74\uc5d0 \ub9de\ub294 \ud589\ub4e4\uc744 \uadf8\ub8f9\uc73c\ub85c \ub098\ub220\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \ub9c8\uc9c0\ub9c9\uc5d0 GROUP BY\ub97c \uc774\uc6a9\ud574\uc57c \ud55c\ub2e4. \uc544\ub798 \ucf54\ub4dc\uc640 \uac19\uc774 WHEN\uc774 \ud558\ub098\ub9cc \ub098\uc640 \ub450 \uac1c\uc758 \uacb0\uacfc(WHEN, ELSE)\uc77c \ub54c\ub97c \ub2e8\uc77c \uc870\uac74 CASE WHEN\uc774\ub77c \ud55c\ub2e4. <\/p>\n\n\n<style>.kb-image2206_5c9a82-4c .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_5c9a82-4c img.kb-img, .kb-image2206_5c9a82-4c .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_5c9a82-4c\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"1024\" height=\"381\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5-1024x381.jpg\" alt=\"SQL CASE WHEN \ub2e8\uc77c \uc870\uac742 \" class=\"kb-img wp-image-2214\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5-1024x381.jpg 1024w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5-300x112.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5-768x286.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5-18x7.jpg 18w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-5.jpg 1059w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_f41f36-58, .wp-block-kadence-advancedheading.kt-adv-heading2206_f41f36-58[data-kb-block=\"kb-adv-heading2206_f41f36-58\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_f41f36-58 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_f41f36-58[data-kb-block=\"kb-adv-heading2206_f41f36-58\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_f41f36-58 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_f41f36-58[data-kb-block=\"kb-adv-heading2206_f41f36-58\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_f41f36-58 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_f41f36-58\">WITH\uc808\uc744 \uc0ac\uc6a9\ud558\ub294 \uc774\uc720\ub294 \uc77c\ub2e8 \uadf8\ub8f9\uc758 \uae30\uc900\uc774 \ub418\ub294 aircraft_size \uceec\ub7fc\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c\uc774\ub2e4. \ub9cc\uc57d WITH\uc808\uc774 \uc5c6\ub2e4\uba74, \uc544\ub798\ucabd\uc5d0 \uc788\ub294 FROM, GROUP BY\uc5d0 \uc774\uc740 SELECT aircraft_size \uceec\ub7fc\uc744 \uac00\uc838\uc624\ub77c\uace0 \uba85\ub839\uc744 \ub530\ub97c \uc218\uac00 \uc5c6\ub2e4. \uc65c\ub0d0\ud558\uba74 \uc544\uc9c1 aircraft_size\uceec\ub7fc\uc744 \ub9cc\ub4e4\uc9c0 \uc54a\uc558\uae30 \ub54c\ubb38\uc774\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_997d4c-7d, .wp-block-kadence-advancedheading.kt-adv-heading2206_997d4c-7d[data-kb-block=\"kb-adv-heading2206_997d4c-7d\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_997d4c-7d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_997d4c-7d[data-kb-block=\"kb-adv-heading2206_997d4c-7d\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_997d4c-7d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_997d4c-7d[data-kb-block=\"kb-adv-heading2206_997d4c-7d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_997d4c-7d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_997d4c-7d\">WITH\uc808\ub9cc \uc77c\ub2e8 \ubcf4\uc790. FROM flights \ud14c\uc774\ube14\uc5d0\uc11c SELECT *(\uc804\uccb4) \uceec\ub7fc\uc744 \uac00\uc838\uc628\ub2e4. \uadf8\ub7f0\ub370 CASE WHEN\uc808 \uc870\uac74\uc5d0\uc11c total_seats \uac01 \ud589\uc758 \ub370\uc774\ud130 \uac12\uc774 300 \uc774\uc0c1\uc774\uba74 Widebody, \uc544\ub2c8\uba74 Narrowbody\ub77c\ub294 \ub370\uc774\ud130 \uac12\uc744 aircraft_size \uc0c8 \uceec\ub7fc\uc5d0 \ub123\uc5b4 \uc900\ub2e4 <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_66013a-d8, .wp-block-kadence-advancedheading.kt-adv-heading2206_66013a-d8[data-kb-block=\"kb-adv-heading2206_66013a-d8\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_66013a-d8 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_66013a-d8[data-kb-block=\"kb-adv-heading2206_66013a-d8\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_66013a-d8 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_66013a-d8[data-kb-block=\"kb-adv-heading2206_66013a-d8\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_66013a-d8 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_66013a-d8\">\uadf8\ub9ac\uace0 \uc774\uac83\uc744 flights_classified\ub77c\ub294 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\uc2dc\ud0a8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uc774\uc81c \ud14c\uc774\ube14\uc5d0\uc11c aircraft_size\ub370\uc774\ud130 \uac12\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_7833f1-f5, .wp-block-kadence-advancedheading.kt-adv-heading2206_7833f1-f5[data-kb-block=\"kb-adv-heading2206_7833f1-f5\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_7833f1-f5 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_7833f1-f5[data-kb-block=\"kb-adv-heading2206_7833f1-f5\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_7833f1-f5 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_7833f1-f5[data-kb-block=\"kb-adv-heading2206_7833f1-f5\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_7833f1-f5 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_7833f1-f5\">\uc774\uc81c \ub450\ubc88\uc9f8 FROM flights_classified \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0, GROUP BY \uadf8\ub8f9\ud654\ub97c \ud558\ub294\ub370 \uae30\uc900\uc740 \ubc14\ub85c aircraft_size\uc774\ub2e4. \uadf8\ub798\uc11c SELECT \uc5d0\uc11c\ub3c4 aircraft_size\ub97c \uba3c\uc800 \uc4f4\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_2725de-17, .wp-block-kadence-advancedheading.kt-adv-heading2206_2725de-17[data-kb-block=\"kb-adv-heading2206_2725de-17\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_2725de-17 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_2725de-17[data-kb-block=\"kb-adv-heading2206_2725de-17\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_2725de-17 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_2725de-17[data-kb-block=\"kb-adv-heading2206_2725de-17\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_2725de-17 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_2725de-17\">count(flight_id)\uc5d0\uc11c flight_id\ub294 \uac01 \ube44\ud589\uae30\ub97c \uc758\ubbf8\ud558\ub294 \ub370, \uadf8 \ud589\uc5d0\uc11c aircraft_size \ub370\uc774\ud130 \uac12\uc744 \uce74\uc6b4\ud2b8\ud558\ub294 \uac83\uc774\ub2e4. flight_id \uccab \ud589\uc5d0\uc11c Widebody\uac00 \ub098\uc624\uba74 1, \uadf8 \ub2e4\uc74c \ud589\uc5d0\uc11cWidebody\uac00 \ub610 \ub098\uc624\uba74 2 \uc774\ub7f0 \uc2dd\uc73c\ub85c \uce74\uc6b4\ud305\uc774 \uc9c4\ud589\ub418\ub294 \uac83\uc774\ub2e4. \uadf8\ub9ac\uace0 \uadf8 \uce74\uc6b4\ud2b8 \ub418\ub294 \uac12\uc744 count \uc0c8 \uceec\ub7fc\uc5d0 \ub123\uc5b4\ub77c\uace0 \ud55c\ub2e4 <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_c123a4-b8, .wp-block-kadence-advancedheading.kt-adv-heading2206_c123a4-b8[data-kb-block=\"kb-adv-heading2206_c123a4-b8\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c123a4-b8 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_c123a4-b8[data-kb-block=\"kb-adv-heading2206_c123a4-b8\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c123a4-b8 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_c123a4-b8[data-kb-block=\"kb-adv-heading2206_c123a4-b8\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_c123a4-b8 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_c123a4-b8\">count(flight_id) * 100 \/ (SELECT COUNT(flight_id) FROM flights) AS percent \ucf54\ub4dc\ub97c \ubcf4\uc790. \uc774 \ucf54\ub4dc\ub294 aircraft_size \uae30\uc900\uc73c\ub85c \uad6c\ubd84\ub418\ub294 \ub370\uc774\ud130 \uadf8\ub8f9\uc774 \uc804\uccb4\uc5d0\uc11c \uc5bc\ub9c8\ub098 \ub418\ub294\uc9c0, \uadf8 \ube44\uc728\uc744 \uc54c\uc544 \ubcf4\ub294 \uac83\uc774\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_06c63e-a0, .wp-block-kadence-advancedheading.kt-adv-heading2206_06c63e-a0[data-kb-block=\"kb-adv-heading2206_06c63e-a0\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_06c63e-a0 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_06c63e-a0[data-kb-block=\"kb-adv-heading2206_06c63e-a0\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_06c63e-a0 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_06c63e-a0[data-kb-block=\"kb-adv-heading2206_06c63e-a0\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_06c63e-a0 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_06c63e-a0\">\uc2a4\uce7c\ub77c \ucffc\ub9ac\uac00 \ubcf4\uc778\ub2e4. (SELECT COUNT(flight_id) FROM flights) \uc774\ub807\uac8c \uc2a4\uce7c\ub77c\ub97c \uc4f0\ub294 \uc774\uc720\ub294 \uc804\uccb4 \uac74\uc218\uac00 \ubd84\ubaa8\ub85c \uc6b0\ub9ac\uac00 \ud544\uc694\ud558\uae30 \ub54c\ubb38\uc774\ub2e4. \uc77c\ub2e8 \uc2a4\uce7c\ub77c \ucffc\ub9ac\ub97c \uc4f0\uba74 \ub3c5\ub9bd\uc801\uc73c\ub85c \uc2e4\ud589\ud558\uac8c \ub418\uc5b4 \ub2e8 \ud558\ub098\uc758 \uac12\uc744 \uac00\uc9c0\uac8c \ub41c\ub2e4. <br><br>\uc774 \uacbd\uc6b0\ub294 \uc804\uccb4 \uac74\uc218\ub97c \uac00\uc9c0\ub294 \uac83\uc774\ub2e4. \uadf8\ub9ac\uace0 \uc704\uc5d0\uc11c GROUP BY\ub97c \uc2e4\ud589\ud588\ub354\ub77c\ub3c4, \uc2a4\uce7c\ub77c \ucffc\ub9ac\ub294 \uadf8 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294\ub2e4. \uc601\ud5a5\uc744 \ubc1b\uc73c\uba74, \ub610 2\uadf8\ub8f9\uc73c\ub85c \ub098\ub220\uc9c0\uae30 \ub54c\ubb38\uc5d0 \uadf8\ub798\uc11c\ub294 \uc548\ub41c\ub2e4. \uadf8\ub9ac\uace0 \uc774\uac83\uc744 percent \uc0c8 \uceec\ub7fc\uc758 \ub370\uc774\ud130 \uac12\uc73c\ub85c \ub123\ub294\ub2e4. <\/p>\n\n\n<style>.kb-image2206_f39c9d-fe .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_f39c9d-fe img.kb-img, .kb-image2206_f39c9d-fe .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_f39c9d-fe\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-6.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"654\" height=\"236\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-6.jpg\" alt=\"SQL CASE WHEN \ub2e8\uc77c \uc870\uac74 \uacb0\uacfc2 \" class=\"kb-img wp-image-2215\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-6.jpg 654w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-6-300x108.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-6-18x6.jpg 18w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_09bfd9-37, .wp-block-kadence-advancedheading.kt-adv-heading2206_09bfd9-37[data-kb-block=\"kb-adv-heading2206_09bfd9-37\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_09bfd9-37 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_09bfd9-37[data-kb-block=\"kb-adv-heading2206_09bfd9-37\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_09bfd9-37 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_09bfd9-37[data-kb-block=\"kb-adv-heading2206_09bfd9-37\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_09bfd9-37 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_09bfd9-37\">WITH\uc808\ub85c aircraft_size \uceec\ub7fc\uc774 \ub9cc\ub4e4\uc5b4\uc84c\uace0, GROUP BY \uadf8\ub8f9\ud654 \uae30\uc900\uc73c\ub85c aircraft_size\uac00 \ub418\uc5c8\uae30\uc5d0 \uadf8 \ub370\uc774\ud130 \uac12\uc778 Narrowbody\uc640 Widebody \uadf8\ub8f9 2\uac1c\ub85c \ub098\ub25c\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_5b6428-97, .wp-block-kadence-advancedheading.kt-adv-heading2206_5b6428-97[data-kb-block=\"kb-adv-heading2206_5b6428-97\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_5b6428-97 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_5b6428-97[data-kb-block=\"kb-adv-heading2206_5b6428-97\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_5b6428-97 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_5b6428-97[data-kb-block=\"kb-adv-heading2206_5b6428-97\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_5b6428-97 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_5b6428-97\">\uac70\uae30\uc11c count(flight_id)\ub97c \ud1b5\ud574 \uac01 \uadf8\ub8f9\uc758 \uac1c\uc218\uac00 \uce74\uc6b4\ud2b8(count \uceec\ub7fc)\ub418\uace0, count(flight_id)\uc640 \uc2a4\uce7c\ub77c \ucffc\ub9ac\ub97c \ud1b5\ud574\uc11c \uc804\uccb4 \ube44\uc728\uc774 \uadf8\ub8f9\ubcc4\ub85c \ucd9c\ub825\ub41c\ub2e4(percent \uceec\ub7fc)<\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_8288ac-3a, .wp-block-kadence-advancedheading.kt-adv-heading2206_8288ac-3a[data-kb-block=\"kb-adv-heading2206_8288ac-3a\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_8288ac-3a mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_8288ac-3a[data-kb-block=\"kb-adv-heading2206_8288ac-3a\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_8288ac-3a img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_8288ac-3a[data-kb-block=\"kb-adv-heading2206_8288ac-3a\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_8288ac-3a wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_8288ac-3a\"><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading has--font-size\">1) CTE \uc5f0\uacb0 <\/h4>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_7fb0d3-01, .wp-block-kadence-advancedheading.kt-adv-heading2206_7fb0d3-01[data-kb-block=\"kb-adv-heading2206_7fb0d3-01\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_7fb0d3-01 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_7fb0d3-01[data-kb-block=\"kb-adv-heading2206_7fb0d3-01\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_7fb0d3-01 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_7fb0d3-01[data-kb-block=\"kb-adv-heading2206_7fb0d3-01\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_7fb0d3-01 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_7fb0d3-01\">SQL \ucf54\ub4dc\ub97c \ub9cc\ub4e4\ub2e4 \ubcf4\uba74, \uc774\ub7f0 \uc2dd\uc73c\ub85c \uc784\uc2dc\ub85c \ub370\uc774\ud130 \uac12\uc744 \uc800\uc7a5\ud574\uc57c \ud558\ub294 \uc5f0\uacb0 \ud14c\uc774\ube14\uc774 \ud544\uc694\ud560 \ub54c\uac00 \uc788\ub2e4. \uc774\uac83\uc744 CTE(Common Table Expression)\uc774\ub77c\uace0 \ud558\uace0, \ub300\ud45c\uc801\uc73c\ub85c WITH\uc808\uacfc \uac19\uc740 \uac83\uc774 CTE\uc758 \uc77c\uc885\uc774\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_3cb03e-dc, .wp-block-kadence-advancedheading.kt-adv-heading2206_3cb03e-dc[data-kb-block=\"kb-adv-heading2206_3cb03e-dc\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_3cb03e-dc mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_3cb03e-dc[data-kb-block=\"kb-adv-heading2206_3cb03e-dc\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_3cb03e-dc img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_3cb03e-dc[data-kb-block=\"kb-adv-heading2206_3cb03e-dc\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_3cb03e-dc wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_3cb03e-dc\"><strong>CTE \uc0ac\uc6a9\ud558\ub294 \uc774\uc720 <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ubcf5\uc7a1\ud55c \ucffc\ub9ac\ub97c&nbsp;\ub2e8\uacc4\ubcc4\ub85c \ub098\ub220\uc11c&nbsp;\uc77d\uae30 \uc27d\uac8c \ub9cc\ub4e4\uc5b4\uc694<\/li>\n\n\n\n<li>\ud55c \ubc88 \uacc4\uc0b0\ud55c \uacb0\uacfc\ub97c&nbsp;\uc5ec\ub7ec \ubc88 \uc7ac\uc0ac\uc6a9\ud560 \uc218 \uc788\uc5b4\uc694<\/li>\n\n\n\n<li>\uac01 \ub2e8\uacc4\uac00&nbsp;\uba85\ud655\ud55c \uc774\ub984\uc744 \uac00\uc9c0\ub2c8 \ucf54\ub4dc\ub97c \uc774\ud574\ud558\uae30 \uc26c\uc6cc\uc694<\/li>\n<\/ul>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_d4056b-62, .wp-block-kadence-advancedheading.kt-adv-heading2206_d4056b-62[data-kb-block=\"kb-adv-heading2206_d4056b-62\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_d4056b-62 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_d4056b-62[data-kb-block=\"kb-adv-heading2206_d4056b-62\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_d4056b-62 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_d4056b-62[data-kb-block=\"kb-adv-heading2206_d4056b-62\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_d4056b-62 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_d4056b-62\">\uc5ec\uae30\uc11c \ub2e4\uc2dc \ud558\ub098 \uc9c8\ubb38\uc744 \ud558\uaca0\ub2e4<\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_c476f2-52, .wp-block-kadence-advancedheading.kt-adv-heading2206_c476f2-52[data-kb-block=\"kb-adv-heading2206_c476f2-52\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c476f2-52 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_c476f2-52[data-kb-block=\"kb-adv-heading2206_c476f2-52\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_c476f2-52 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_c476f2-52[data-kb-block=\"kb-adv-heading2206_c476f2-52\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_c476f2-52 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_c476f2-52\">\ube44\ud589\uae30 \uc804\uccb4 \uc88c\uc11d\uc5d0\uc11c \ud0d1\uc2b9\ud558\ub294 \uc2b9\uac1d \uc218\ub85c \ube44\uc728\ub85c \ud55c \uac83\uc744 occupancy\ub77c\uace0 \ud558\uc790. \uc774 occupancy\uac00 90\uc774\uc0c1 \uc774\uba74 full, 70\uc774\uc0c1 \uc774\uba74 high, \uadf8 \ub098\uba38\uc9c0\ub294 low\ub77c\uace0 \ud558\uace0 \uc774\uac83\uc744 occupancy_status\ub77c\ub294 \uc0c8 \uceec\ub7fc\uc5d0 \ub123\uc5b4\ub77c. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_029598-63, .wp-block-kadence-advancedheading.kt-adv-heading2206_029598-63[data-kb-block=\"kb-adv-heading2206_029598-63\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_029598-63 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_029598-63[data-kb-block=\"kb-adv-heading2206_029598-63\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_029598-63 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_029598-63[data-kb-block=\"kb-adv-heading2206_029598-63\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_029598-63 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_029598-63\">\uadf8\ub9ac\uace0 \uc774 occupancy_status \uceec\ub7fc\uc758 \uadf8\ub8f9 \ubcc4 \uac1c\uc218\uc640 \uc804\uccb4\uc5d0\uc11c \uadf8\ub8f9\ubcc4 \ube44\uc728\uc744 \uad6c\ud558\ub77c <\/p>\n\n\n<style>.kb-image2206_f0fe3b-b0 .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_f0fe3b-b0 img.kb-img, .kb-image2206_f0fe3b-b0 .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_f0fe3b-b0\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"1024\" height=\"379\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7-1024x379.jpg\" alt=\"SQL CASE WHEN \ub2e4\uc911 \uc870\uac74\" class=\"kb-img wp-image-2216\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7-1024x379.jpg 1024w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7-300x111.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7-768x284.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7-18x7.jpg 18w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-7.jpg 1052w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_1f06fe-80, .wp-block-kadence-advancedheading.kt-adv-heading2206_1f06fe-80[data-kb-block=\"kb-adv-heading2206_1f06fe-80\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_1f06fe-80 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_1f06fe-80[data-kb-block=\"kb-adv-heading2206_1f06fe-80\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_1f06fe-80 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_1f06fe-80[data-kb-block=\"kb-adv-heading2206_1f06fe-80\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_1f06fe-80 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_1f06fe-80\"> \uc6b0\uc120 \uac00\uc7a5 \uba3c\uc800 \uc2e4\ud589\ub418\ub294 WITH\uc808 \ubd80\ud130 \uc598\uae30\ud574 \ubcf4\uc790. occupancy \uc0c8 \uceec\ub7fc\uc744 \ub9cc\ub4e4\uc5c8\ub2e4. \uadf8\ub9ac\uace0 \uadf8\uac8c 90\uc774\uc0c1\uc774\uba74 full, 70\uc774\uc0c1\uc774\uba74 high, \uadf8 \ub098\uba38\uc9c0\ub294 low \ub4f1\uae09\uc744 \ub098\ub208 \ub370\uc774\ud130 \uac12\uc744 occupancy_status \uceec\ub7fc\uc5d0 \ub123\uc5c8\ub2e4. \uadf8\ub9ac\uace0 \uc0c8\ub85c \ub9cc\ub4e0 \uc774 \uceec\ub7fc\ub4e4\uc744 flights_occupancy \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud588\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_0a6009-19, .wp-block-kadence-advancedheading.kt-adv-heading2206_0a6009-19[data-kb-block=\"kb-adv-heading2206_0a6009-19\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_0a6009-19 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_0a6009-19[data-kb-block=\"kb-adv-heading2206_0a6009-19\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_0a6009-19 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_0a6009-19[data-kb-block=\"kb-adv-heading2206_0a6009-19\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_0a6009-19 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_0a6009-19\">\uadf8\ub9ac\uace0 \uc544\ub798 FROM\uc5d0\uc11c flights_occupancy \ud14c\uc774\ube14\uc744 \uac00\uc838\uc624\uace0, occupancy_status \uae30\uc900\uc73c\ub85c Group by\ub97c \ud55c\ub2e4. \uadf8\ub9ac\uace0 SELECT\uc5d0\uc11c\ub294 \uc804\uccb4 \uac74\uc218\uc640 \uac01 \uadf8\ub8f9\ubcc4 \ube44\uc728\uc744 \uac00\uc838\uc624\ub294 \ucf54\ub4dc\uc774\ub2e4. \uc2a4\uce7c\ub77c \ucffc\ub9ac \ubd80\ubd84\uc740 \uc704\uc5d0\uc11c \uc774\ubbf8 \uc124\uba85\uc744 \ud588\uae30 \ub54c\ubb38\uc5d0 \ub354 \uc774\uc0c1 \uc124\uba85\ud558\uc9c0 \uc54a\uaca0\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_2c480d-31, .wp-block-kadence-advancedheading.kt-adv-heading2206_2c480d-31[data-kb-block=\"kb-adv-heading2206_2c480d-31\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_2c480d-31 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_2c480d-31[data-kb-block=\"kb-adv-heading2206_2c480d-31\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_2c480d-31 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_2c480d-31[data-kb-block=\"kb-adv-heading2206_2c480d-31\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_2c480d-31 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_2c480d-31\">\uadf8\ub9ac\uace0 \uc704\uc758 \ucf54\ub4dc\uc5d0\uc11c\ub294 3\uac1c \uc774\uc0c1\uc758 \uacb0\uacfc(WHEN 2\ubc88, ELSE)\uac00 \ub098\uc624\ub294\ub370, \uc774\ub97c \ub2e4\uc911 \uc870\uac74\uc774\ub77c\uace0 \ud55c\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_447315-ab, .wp-block-kadence-advancedheading.kt-adv-heading2206_447315-ab[data-kb-block=\"kb-adv-heading2206_447315-ab\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_447315-ab mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_447315-ab[data-kb-block=\"kb-adv-heading2206_447315-ab\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_447315-ab img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_447315-ab[data-kb-block=\"kb-adv-heading2206_447315-ab\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_447315-ab wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_447315-ab\">SQL CASE WHEN \uc704\uc758 \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uba74, \uacb0\uacfc\uac12\uc740 \uc544\ub798\uc640 \uac19\uc774 \ub098\uc628\ub2e4. <\/p>\n\n\n<style>.kb-image2206_707fc1-dc .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image2206_707fc1-dc img.kb-img, .kb-image2206_707fc1-dc .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:10px 10px 20px 0px rgba(0, 0, 0, 0.2);filter:drop-shadow(0px 0px 14px rgba(0, 0, 0, 0.2));}<\/style>\n<div class=\"wp-block-kadence-image kb-image2206_707fc1-dc\"><figure class=\"aligncenter size-medium_large\"><a href=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-8.jpg\" class=\"kb-advanced-image-link\"><img decoding=\"async\" width=\"811\" height=\"306\" src=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-8.jpg\" alt=\"SQL CASE WHEN \ub2e4\uc911 \uc870\uac74 \uacb0\uacfc \" class=\"kb-img wp-image-2218\" srcset=\"https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-8.jpg 811w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-8-300x113.jpg 300w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-8-768x290.jpg 768w, https:\/\/nzwonderland.com\/wp-content\/uploads\/2026\/04\/image-8-18x7.jpg 18w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/a><\/figure><\/div>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_95f41c-2f, .wp-block-kadence-advancedheading.kt-adv-heading2206_95f41c-2f[data-kb-block=\"kb-adv-heading2206_95f41c-2f\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_95f41c-2f mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_95f41c-2f[data-kb-block=\"kb-adv-heading2206_95f41c-2f\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_95f41c-2f img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_95f41c-2f[data-kb-block=\"kb-adv-heading2206_95f41c-2f\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_95f41c-2f wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_95f41c-2f\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading has--font-size\">\ub9c8\ubb34\ub9ac <\/h2>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_a99a90-3d, .wp-block-kadence-advancedheading.kt-adv-heading2206_a99a90-3d[data-kb-block=\"kb-adv-heading2206_a99a90-3d\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_a99a90-3d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_a99a90-3d[data-kb-block=\"kb-adv-heading2206_a99a90-3d\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_a99a90-3d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_a99a90-3d[data-kb-block=\"kb-adv-heading2206_a99a90-3d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_a99a90-3d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_a99a90-3d\">\uc624\ub298\uc740 SQL CASE WHEN\uc808\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130 \uc870\uc791 \uc870\uac74\ubd80 \ubcc0\ud658\uc5d0 \ub300\ud574\uc11c \uc774\uc57c\uae30\ud574 \ubcf4\uc558\ub2e4. \uac01 \ud589\uc5d0 \ub300\ud574 \uc870\uac74\uc744 \ud3c9\uac00\ud558\uace0, \ucda9\uc871\ub418\ub294 \uc870\uac74\uc5d0 \ub530\ub77c \uc11c\ub85c \ub2e4\ub978 \ub85c\uc9c1\uc744 \uc801\uc6a9\ud558\uc5ec \uc0c8\ub85c\uc6b4 \uceec\ub7fc\uc744 \uc0dd\uc131\ud558\ub294 \uac83\uc73c\ub85c \uc774\ud574\ud558\uba74 \ub418\uaca0\ub2e4. <\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_35f65d-ba, .wp-block-kadence-advancedheading.kt-adv-heading2206_35f65d-ba[data-kb-block=\"kb-adv-heading2206_35f65d-ba\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_35f65d-ba mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_35f65d-ba[data-kb-block=\"kb-adv-heading2206_35f65d-ba\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_35f65d-ba img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_35f65d-ba[data-kb-block=\"kb-adv-heading2206_35f65d-ba\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_35f65d-ba wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_35f65d-ba\">\uc800\ucc98\ub7fc \ube44\uc804\uacf5\uc790\uc778\ub370, \ub370\uc774\ud130 \ubd84\uc11d\uac00\uc5d0 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0 \ubd84\ub4e4\uc740 \uc81c\uac00 Datacamp \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uacf5\ubd80\ud55c SQL\uc5d0 \ub300\ud55c \ud3ec\uc2a4\ud305\uc744 \ubcf4\uc2dc\uba74 \ud6e8\uc52c \uc774\ud574\uac00 \uc798 \uac00\uc2e4 \ud14c\ub2c8 \uaf2d \ud55c\ubc88 \uc77d\uc5b4 \ubcf4\uc138\uc694. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/nzwonderland.com\/new-zealand-data-analyst-useful-skill-non-major\/\" data-type=\"post\" data-id=\"1942\">SQL \uc785\ubb38 \uac00\uc774\ub4dc \ubc0f \uae30\ubcf8 \ucffc\ub9ac \uc791\uc131<\/a> <\/li>\n\n\n\n<li><a href=\"https:\/\/nzwonderland.com\/aggregation-function-sql-grouping-group-by\/\" data-type=\"post\" data-id=\"2153\">SQL \uadf8\ub8f9\ud654 (GROUP BY)<\/a> <\/li>\n\n\n\n<li><a href=\"https:\/\/nzwonderland.com\/sql-data-transformation-business-metrics\/\" data-type=\"post\" data-id=\"2175\">SQL \ub370\uc774\ud130 \ubd84\uc11d \uc911 \uac00\uc7a5 \ub9ce\uc774 \ub098\uc624\ub294 \ube44\uc988\ub2c8\uc2a4 \ud575\uc2ec \uc9c0\ud45c \uc54c\uc544\ubcf4\uae30<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/nzwonderland.com\/tag\/sql%eb%8d%b0%ec%9d%b4%ed%84%b0%ed%95%84%ed%84%b0%eb%a7%81\/\" data-type=\"post_tag\" data-id=\"430\">SQL \ud544\ud130\ub9c1<\/a> <\/li>\n<\/ul>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_581e15-61, .wp-block-kadence-advancedheading.kt-adv-heading2206_581e15-61[data-kb-block=\"kb-adv-heading2206_581e15-61\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_581e15-61 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_581e15-61[data-kb-block=\"kb-adv-heading2206_581e15-61\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_581e15-61 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_581e15-61[data-kb-block=\"kb-adv-heading2206_581e15-61\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_581e15-61 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_581e15-61\"><\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_6a27a2-e0, .wp-block-kadence-advancedheading.kt-adv-heading2206_6a27a2-e0[data-kb-block=\"kb-adv-heading2206_6a27a2-e0\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_6a27a2-e0 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_6a27a2-e0[data-kb-block=\"kb-adv-heading2206_6a27a2-e0\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_6a27a2-e0 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_6a27a2-e0[data-kb-block=\"kb-adv-heading2206_6a27a2-e0\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_6a27a2-e0 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_6a27a2-e0\"><\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_6ecf26-01, .wp-block-kadence-advancedheading.kt-adv-heading2206_6ecf26-01[data-kb-block=\"kb-adv-heading2206_6ecf26-01\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_6ecf26-01 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_6ecf26-01[data-kb-block=\"kb-adv-heading2206_6ecf26-01\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_6ecf26-01 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_6ecf26-01[data-kb-block=\"kb-adv-heading2206_6ecf26-01\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_6ecf26-01 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_6ecf26-01\"><br><\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_61c4d0-ad, .wp-block-kadence-advancedheading.kt-adv-heading2206_61c4d0-ad[data-kb-block=\"kb-adv-heading2206_61c4d0-ad\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_61c4d0-ad mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_61c4d0-ad[data-kb-block=\"kb-adv-heading2206_61c4d0-ad\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_61c4d0-ad img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_61c4d0-ad[data-kb-block=\"kb-adv-heading2206_61c4d0-ad\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_61c4d0-ad wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_61c4d0-ad\"><\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading2206_fd922e-4d, .wp-block-kadence-advancedheading.kt-adv-heading2206_fd922e-4d[data-kb-block=\"kb-adv-heading2206_fd922e-4d\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading2206_fd922e-4d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading2206_fd922e-4d[data-kb-block=\"kb-adv-heading2206_fd922e-4d\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading2206_fd922e-4d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading2206_fd922e-4d[data-kb-block=\"kb-adv-heading2206_fd922e-4d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading2206_fd922e-4d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading2206_fd922e-4d\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As you analyze data, you will inevitably encounter conditional transformations. In this case, SQL CASE...<\/p>","protected":false},"author":1,"featured_media":2221,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[389],"tags":[434,437,436,435],"class_list":{"0":"post-2206","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-389","8":"tag-sqlcasewhen","9":"tag-sql","11":"tag-435"},"_links":{"self":[{"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/posts\/2206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/comments?post=2206"}],"version-history":[{"count":6,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/posts\/2206\/revisions"}],"predecessor-version":[{"id":2222,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/posts\/2206\/revisions\/2222"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/media\/2221"}],"wp:attachment":[{"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/media?parent=2206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/categories?post=2206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nzwonderland.com\/en\/wp-json\/wp\/v2\/tags?post=2206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}