--- title: Learn SQL while solving crimes! SQL Police Department description: Structured Query Language (SQL) is a powerful language used to access and manipulate data in tables. Key operations include selecting all or specific columns,... canonical: https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Learn SQL while solving crimes! SQL Police Department | daily.dev og:description: Structured Query Language (SQL) is a powerful language used to access and manipulate data in tables. Key operations include selecting all or specific columns,... og:url: https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv og:image: https://api.daily.dev/og/posts/FzEJWRWJV.png og:image:alt: Learn SQL while solving crimes! SQL Police Department og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Learn SQL while solving crimes! SQL Police Department **[Community Picks](https://daily.dev/sources/community)** · 7 min read · 2566 upvotes · 114 comments ## Summary Structured Query Language (SQL) is a powerful language used to access and manipulate data in tables. Key operations include selecting all or specific columns, filtering and sorting rows, eliminating duplicates, and using conditional statements to refine data queries. Understanding these basics enables effective data management and retrieval. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@lkhagvadelger** · 21 upvotes > Nice, very fun way to learn sql for beginners. **@nadia35** · 15 upvotes > Very nice for sql beginners, will be more fun if u can tap instead of clicking the commands. **@yagnikvamja** · 5 upvotes > Amazing.. Love it.. **@tobinguyen** · 3 upvotes > Pretty cool and fun for beginners to learn, rather than having to sit and read through a long, boring document. **@basitshaikh62** · 2 upvotes >  ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 1 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#sql](https://daily.dev/tags/sql), [#data-analysis](https://daily.dev/tags/data-analysis) [View this post on daily.dev](https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Learn SQL while solving crimes! SQL Police Department","url":"https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv"},"datePublished":"2024-12-02T14:59:44.134Z","dateModified":"2025-02-24T19:55:08.497Z","description":"Structured Query Language (SQL) is a powerful language used to access and manipulate data in tables. Key operations include selecting all or specific columns,...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/1b52c3e1587f08e7cfb05d40b3063ea7?_a=AQAEuj9","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/1b52c3e1587f08e7cfb05d40b3063ea7?_a=AQAEuj9","isAccessibleForFree":true,"articleSection":"Community Picks","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Community Picks","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community","url":"https://daily.dev/sources/community"},"commentCount":114,"discussionUrl":"https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2566},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":114}],"keywords":"database,sql,data-analysis","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Community Picks","item":"https://daily.dev/sources/community"},{"@type":"ListItem","position":3,"name":"Learn SQL while solving crimes! SQL Police Department"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/learn-sql-while-solving-crimes-sql-police-department-fzejwrwjv","comment":[{"@type":"Comment","text":"Nice, very fun way to learn sql for beginners.","datePublished":"2024-12-28T05:34:36.989Z","url":"https://daily.dev/posts/FzEJWRWJV#c-KziwTJ7ww","author":{"@type":"Person","name":"Lkhagvadelger","url":"https://daily.dev/lkhagvadelger","image":"https://lh3.googleusercontent.com/a/ACg8ocIdk5b_UhCsYBnaysRabMjN3TYBKn_h4PYcpYVbPIo5rQy4Z-7obA=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":21}},{"@type":"Comment","text":"Very nice for sql beginners, will be more fun if u can tap instead of clicking the commands.","datePublished":"2024-12-29T16:05:05.027Z","url":"https://daily.dev/posts/FzEJWRWJV#c-LyNv2OLt2","author":{"@type":"Person","name":"Nadia","url":"https://daily.dev/nadia35","image":"https://media.daily.dev/image/upload/s--aBNJFoYb--/f_auto/v1727731859/avatars/avatar_b8XpippYSV0AqOltvoWEX"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":15}},{"@type":"Comment","text":"Amazing… Love it…","datePublished":"2025-01-01T10:03:04.995Z","url":"https://daily.dev/posts/FzEJWRWJV#c-ntFiGRpei","author":{"@type":"Person","name":"Yagnik Vamja","url":"https://daily.dev/yagnikvamja","image":"https://media.daily.dev/image/upload/s--ueCkXI9T--/f_auto/v1735121313/avatars/avatar_qIzt5wXFEeqFgMSm5wucB"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":5}},{"@type":"Comment","text":"Pretty cool and fun for beginners to learn, rather than having to sit and read through a long, boring document.","datePublished":"2024-12-30T02:19:13.565Z","url":"https://daily.dev/posts/FzEJWRWJV#c-PJjpq7ppe","author":{"@type":"Person","name":"Tobi","url":"https://daily.dev/tobinguyen","image":"https://lh3.googleusercontent.com/a-/AOh14GimFALXyTdP1_Au2jv3Tymzp2S8LGamR-Y3B40s=s100"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":3}},{"@type":"Comment","text":"","datePublished":"2025-01-02T04:24:12.890Z","url":"https://daily.dev/posts/FzEJWRWJV#c-SVP6Frp83","author":{"@type":"Person","name":"Basit Shaikh","url":"https://daily.dev/basitshaikh62","image":"https://lh3.googleusercontent.com/a/ACg8ocJftkdvTIqH7KYDVVVs99vPmbjACbJLCiv5n7L4feKQiHctSpKt=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2}}]} ```