{"id":10062,"date":"2024-08-05T11:35:56","date_gmt":"2024-08-05T09:35:56","guid":{"rendered":"https:\/\/www.panter.ch\/?p=10062"},"modified":"2024-12-03T17:03:47","modified_gmt":"2024-12-03T16:03:47","slug":"wrong-sql-query-wrong-decisions","status":"publish","type":"post","link":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/","title":{"rendered":"How an incorrect SQL query leads to wrong decisions"},"content":{"rendered":"[vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” top_padding_phone=”12vw” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none” gradient_type=”default” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”10px” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid” column_padding_type=”default” gradient_type=”default”][vc_column_text css=”” text_direction=”default”]In today’s business world, the ability to make data-driven decisions is critical to an organization’s success.
\nMany companies rely on analyzing internal data to support key C-level decisions.
\nThis data includes metrics such as the number of new and churned customers, customer segmentation and performance metrics.
\nBut what happens if the underlying SQL query is faulty?[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” top_padding=”40px” top_padding_phone=”12vw” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none” gradient_type=”default” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”10px” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid” column_padding_type=”default” gradient_type=”default”][vc_column_text css=”” text_direction=”default”]\n

Example: Effects of an incorrect SQL query<\/h2>\n[\/vc_column_text][vc_column_text css=”” text_direction=”default”]A recent example from Senior Data Engineer Juri Sarbach’s own experience shows how a supposedly small discrepancy in an SQL query can have serious consequences.
\nAt one of our customers, the company regularly analyzed its internal data in order to make strategic decisions.
\nHowever, the SQL query used to calculate the key figures and KPIs was not entirely correct.
\nThe resulting figures deviated from reality, but not to such an extent that the error was immediately obvious.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Main cause: lack of data analytics expertise<\/h3>\n[\/vc_column_text][vc_column_text css=”” text_direction=”default”]The main cause of the problem was the lack of the necessary data analytics expertise within the company.
\nWithout the necessary expertise to create and validate SQL queries, management made decisions based on incorrect evaluations.
\nThis could have led to strategic mistakes that could have cost the company dearly.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Need for qualified data analysts<\/h3>\n

[\/vc_column_text][vc_column_text css=”” text_direction=”default”]Despite the company’s laudable intention to act in a data-driven manner, the basis for this was lacking – in particular the necessary skillset.
\nWithout qualified data analysts who are able to evaluate and interpret data correctly, the “data-driven” approach remains a dangerous illusion.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Skills development for error prevention in SQL queries<\/h3>\n[\/vc_column_text][vc_column_text css=”” text_direction=”default”]This case shows how important it is to have a good understanding of data analysis and to invest in the relevant skills.
\nOnly in this way can companies ensure that their data-based decisions are based on solid foundations and not on false assumptions.
\nA strong team with these skills can not only identify and correct errors in SQL queries, but also raise the quality of decisions to a new level.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

The path to a data-driven corporate culture<\/h3>\n[\/vc_column_text][vc_column_text css=”” text_direction=”default”]Ultimately, this case shows that the path to a truly data-driven corporate culture<\/a> is not just about collecting data, but also about developing and deploying the right skills and technologies.
\nThis is the only way to ensure that decisions are truly based on reliable data and that the company is successful in the long term.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Conclusion: Importance of correct data interpretation<\/h2>\n[\/vc_column_text][vc_column_text css=”” text_direction=”default”]Our experience with our client has shown us how important it is not only to collect data, but also to ensure that this data is interpreted and used correctly.
\nA small mistake in data analysis can have a big impact – but with the right skills and a dedicated team, these risks can be minimized and the full potential of the data can be exploited.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]Find out more about data-based management in our detailed blog post<\/a>.[\/vc_column_text][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"

Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.<\/p>\n","protected":false},"author":3,"featured_media":10069,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"inline_featured_image":false,"footnotes":""},"categories":[276,274],"tags":[],"class_list":["post-10062","post","type-post","status-publish","format-standard","has-post-thumbnail","category-ai-data-en","category-blog-en"],"yoast_head":"\nHow an incorrect SQL query leads to wrong decisions<\/title>\n<meta name=\"description\" content=\"Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How an incorrect SQL query leads to wrong decisions\" \/>\n<meta property=\"og:description\" content=\"Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/\" \/>\n<meta property=\"og:site_name\" content=\"Panter AG\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/panterch\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-05T09:35:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-03T16:03:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.panter.ch\/wp-content\/uploads\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1792\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Roberto\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@panterch\" \/>\n<meta name=\"twitter:site\" content=\"@panterch\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Roberto\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/\"},\"author\":{\"name\":\"Roberto\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#\\\/schema\\\/person\\\/17955a8092d4a5671347f2f158635479\"},\"headline\":\"How an incorrect SQL query leads to wrong decisions\",\"datePublished\":\"2024-08-05T09:35:56+00:00\",\"dateModified\":\"2024-12-03T16:03:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/\"},\"wordCount\":1902,\"publisher\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.panter.ch\\\/wp-content\\\/uploads\\\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp\",\"articleSection\":[\"AI & Data\",\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/\",\"url\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/\",\"name\":\"How an incorrect SQL query leads to wrong decisions\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.panter.ch\\\/wp-content\\\/uploads\\\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp\",\"datePublished\":\"2024-08-05T09:35:56+00:00\",\"dateModified\":\"2024-12-03T16:03:47+00:00\",\"description\":\"Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.panter.ch\\\/wp-content\\\/uploads\\\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp\",\"contentUrl\":\"https:\\\/\\\/www.panter.ch\\\/wp-content\\\/uploads\\\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp\",\"width\":1792,\"height\":1024,\"caption\":\"Teaserbild f\u00fcr Artikel Wie eine falsche SQL Query zu Fehlentscheidungen f\u00fchrt\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/stories\\\/wrong-sql-query-wrong-decisions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/salient-architect-landing\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How an incorrect SQL query leads to wrong decisions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/\",\"name\":\"Panter AG\",\"description\":\"Smarter, better, human.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#organization\",\"name\":\"Panter AG\",\"alternateName\":\"Panter\",\"url\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.panter.ch\\\/wp-content\\\/uploads\\\/Panter_Favicon_696x696.jpg\",\"contentUrl\":\"https:\\\/\\\/www.panter.ch\\\/wp-content\\\/uploads\\\/Panter_Favicon_696x696.jpg\",\"width\":696,\"height\":696,\"caption\":\"Panter AG\"},\"image\":{\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/panterch\",\"https:\\\/\\\/x.com\\\/panterch\",\"https:\\\/\\\/ch.linkedin.com\\\/company\\\/panter-ch\",\"https:\\\/\\\/www.instagram.com\\\/panter.ch\\\/\",\"https:\\\/\\\/github.com\\\/panter\"],\"description\":\"Wir von Panter sind Macher und Techies mit interdisziplin\u00e4rem Know-how \u2013 von Softwareentwicklung \u00fcber Design bis zu AI-Expertise. Mit innovativen, nutzerzentrierten L\u00f6sungen, modernster Technologie und einem starken Netzwerk entwickeln wir Services, die Ihre Nutzer begeistern und Ihr Unternehmen voranbringen. Als Schweizer Software- und Beratungsunternehmen stehen wir f\u00fcr Qualit\u00e4t, Innovationskraft und partnerschaftliche Zusammenarbeit \u2013 mit Herz und Verstand.\",\"email\":\"hello@panter.ch\",\"telephone\":\"+41 44 500 29 04\",\"legalName\":\"Panter AG\",\"foundingDate\":\"2005-01-01\",\"vatID\":\"CHE-262.202.358\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.panter.ch\\\/en\\\/#\\\/schema\\\/person\\\/17955a8092d4a5671347f2f158635479\",\"name\":\"Roberto\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/63049a62ffa6445b337ce3fa0e7ad5dbf289f7541d5f9e0f10d871cc3b4241a8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/63049a62ffa6445b337ce3fa0e7ad5dbf289f7541d5f9e0f10d871cc3b4241a8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/63049a62ffa6445b337ce3fa0e7ad5dbf289f7541d5f9e0f10d871cc3b4241a8?s=96&d=mm&r=g\",\"caption\":\"Roberto\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How an incorrect SQL query leads to wrong decisions","description":"Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/","og_locale":"en_US","og_type":"article","og_title":"How an incorrect SQL query leads to wrong decisions","og_description":"Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.","og_url":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/","og_site_name":"Panter AG","article_publisher":"https:\/\/www.facebook.com\/panterch","article_published_time":"2024-08-05T09:35:56+00:00","article_modified_time":"2024-12-03T16:03:47+00:00","og_image":[{"width":1792,"height":1024,"url":"https:\/\/www.panter.ch\/wp-content\/uploads\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp","type":"image\/webp"}],"author":"Roberto","twitter_card":"summary_large_image","twitter_creator":"@panterch","twitter_site":"@panterch","twitter_misc":{"Written by":"Roberto","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#article","isPartOf":{"@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/"},"author":{"name":"Roberto","@id":"https:\/\/www.panter.ch\/en\/#\/schema\/person\/17955a8092d4a5671347f2f158635479"},"headline":"How an incorrect SQL query leads to wrong decisions","datePublished":"2024-08-05T09:35:56+00:00","dateModified":"2024-12-03T16:03:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/"},"wordCount":1902,"publisher":{"@id":"https:\/\/www.panter.ch\/en\/#organization"},"image":{"@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.panter.ch\/wp-content\/uploads\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp","articleSection":["AI & Data","Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/","url":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/","name":"How an incorrect SQL query leads to wrong decisions","isPartOf":{"@id":"https:\/\/www.panter.ch\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#primaryimage"},"image":{"@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.panter.ch\/wp-content\/uploads\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp","datePublished":"2024-08-05T09:35:56+00:00","dateModified":"2024-12-03T16:03:47+00:00","description":"Discover how faulty SQL queries can lead to wrong decisions and how you can minimize these risks.","breadcrumb":{"@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#primaryimage","url":"https:\/\/www.panter.ch\/wp-content\/uploads\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp","contentUrl":"https:\/\/www.panter.ch\/wp-content\/uploads\/falsche_query_falsche_geschaeftsentscheidungen_teaser.webp","width":1792,"height":1024,"caption":"Teaserbild f\u00fcr Artikel Wie eine falsche SQL Query zu Fehlentscheidungen f\u00fchrt"},{"@type":"BreadcrumbList","@id":"https:\/\/www.panter.ch\/en\/stories\/wrong-sql-query-wrong-decisions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.panter.ch\/en\/salient-architect-landing\/"},{"@type":"ListItem","position":2,"name":"How an incorrect SQL query leads to wrong decisions"}]},{"@type":"WebSite","@id":"https:\/\/www.panter.ch\/en\/#website","url":"https:\/\/www.panter.ch\/en\/","name":"Panter AG","description":"Smarter, better, human.","publisher":{"@id":"https:\/\/www.panter.ch\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.panter.ch\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.panter.ch\/en\/#organization","name":"Panter AG","alternateName":"Panter","url":"https:\/\/www.panter.ch\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.panter.ch\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.panter.ch\/wp-content\/uploads\/Panter_Favicon_696x696.jpg","contentUrl":"https:\/\/www.panter.ch\/wp-content\/uploads\/Panter_Favicon_696x696.jpg","width":696,"height":696,"caption":"Panter AG"},"image":{"@id":"https:\/\/www.panter.ch\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/panterch","https:\/\/x.com\/panterch","https:\/\/ch.linkedin.com\/company\/panter-ch","https:\/\/www.instagram.com\/panter.ch\/","https:\/\/github.com\/panter"],"description":"Wir von Panter sind Macher und Techies mit interdisziplin\u00e4rem Know-how \u2013 von Softwareentwicklung \u00fcber Design bis zu AI-Expertise. Mit innovativen, nutzerzentrierten L\u00f6sungen, modernster Technologie und einem starken Netzwerk entwickeln wir Services, die Ihre Nutzer begeistern und Ihr Unternehmen voranbringen. Als Schweizer Software- und Beratungsunternehmen stehen wir f\u00fcr Qualit\u00e4t, Innovationskraft und partnerschaftliche Zusammenarbeit \u2013 mit Herz und Verstand.","email":"hello@panter.ch","telephone":"+41 44 500 29 04","legalName":"Panter AG","foundingDate":"2005-01-01","vatID":"CHE-262.202.358","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.panter.ch\/en\/#\/schema\/person\/17955a8092d4a5671347f2f158635479","name":"Roberto","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/63049a62ffa6445b337ce3fa0e7ad5dbf289f7541d5f9e0f10d871cc3b4241a8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/63049a62ffa6445b337ce3fa0e7ad5dbf289f7541d5f9e0f10d871cc3b4241a8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63049a62ffa6445b337ce3fa0e7ad5dbf289f7541d5f9e0f10d871cc3b4241a8?s=96&d=mm&r=g","caption":"Roberto"}}]}},"_links":{"self":[{"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/posts\/10062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/comments?post=10062"}],"version-history":[{"count":5,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/posts\/10062\/revisions"}],"predecessor-version":[{"id":10425,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/posts\/10062\/revisions\/10425"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/media\/10069"}],"wp:attachment":[{"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/media?parent=10062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/categories?post=10062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.panter.ch\/en\/wp-json\/wp\/v2\/tags?post=10062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}