SQL Tips and Tricks for Data Analysts

[{"selector":"#anim-e43c108b-d69e-4ec5-887f-88985852fe9f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, 7.760782355151471e-15%, 0)","translate3d(0, 0%, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-85135ab7-7c1d-42a5-a586-f2be51235f60","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3033b6e3-ff09-4775-b108-5bdf8fbda30d","keyframes":{"transform":["translate3d(0px, 274.30550%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b3a5d0b3-df60-4584-9b9d-b5252ac5fe69","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-077e45a9-ce9e-49c2-bb09-abc5f57fbdad","keyframes":{"transform":["translate3d(0px, 404.53847%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Master SQL Alchemy

[{"selector":"#anim-3505a570-71aa-491c-8173-ac8be5364acc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-321fcce0-d4ff-446b-93a9-9131c9ad0311","keyframes":{"transform":["translate3d(0px, 171.24182%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c093d93f-4780-4d8a-a0b0-0ab673ff1576","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6b2b9cad-2af4-44f0-ac7a-4ee4049000fd","keyframes":{"transform":["translate3d(-155.5%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8077c446-accf-480a-b636-2c062c4b94b1","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-17f42e0c-da26-4c70-99f4-8e0649247bd1","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-303a457b-70f5-487c-aa1b-58929105502a","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b5c3dd89-dc7b-450b-b94d-4c86fbb3985c","keyframes":{"transform":["translate3d(0px, 169.42976%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a4df15a7-361e-4aac-a7c8-7b7b35f5a043","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-310138a9-257c-4cc8-8d5c-9fdd03381b8a","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

Window Functions Unleashed

[{"selector":"#anim-c8304ec3-4204-42ea-adaf-fa932c4fd6c4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8fa1fd0e-c2fa-4631-b0f2-576c540cf8b0","keyframes":{"transform":["translate3d(0px, 138.45853%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5be513b9-7108-49f5-a7aa-dd46e97ceefa","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3b15f818-1fa6-421e-9ac3-3c1c8a7160aa","keyframes":{"transform":["translate3d(-118.12297%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-361c1a5c-1fd5-45d1-a3e2-78601a9fba00","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7f5ca7a0-3c3b-4f49-8cea-c4d80c813ce1","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-58ccf205-e64e-483f-b703-355ad4fee8be","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eef5044c-13aa-4278-8b6e-2d37a5f15ff1","keyframes":{"transform":["translate3d(0px, 146.72469%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8905a97c-2bab-4670-86f3-cd0e4a7184c7","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ba54069a-f999-4ec1-a82a-2d04bcf32319","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

Common Table Expressions (CTEs): Your Friend

[{"selector":"#anim-8bb8977f-8b0b-4bd1-bc8b-eface2016dbf","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-30de40ae-b0dc-4226-b72c-fdd95b33172f","keyframes":{"transform":["translate3d(0px, 145.68892%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-442bf4e2-808d-4c06-a20a-cf7d41a49a03","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d00a9bb3-e209-4fc8-8951-3249732f3d58","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eef30470-a50c-4a19-8dc7-9c04747199ee","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-00e7267b-253d-4be7-91e5-8a2aeb65811a","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-7a6e1765-d082-49b3-93ec-7bea1a2d0f9d","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5f2018cb-83f2-499f-9fe6-0783de6aba67","keyframes":{"transform":["translate3d(0px, 157.92269%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0ad0fbc2-d4f5-42ba-b602-bc8476d9ddd1","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3644afff-c9b3-4087-99e9-559063fb951b","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

JOIN Mastery

[{"selector":"#anim-b94e2b71-f4bb-4b9e-baf4-197e9cc33304","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ac438746-432b-44b8-8160-fed208a769d2","keyframes":{"transform":["translate3d(0px, 144.32748%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ac0cb7ab-01ad-4865-b59b-50088350b1d1","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-246c9957-a195-40b7-9336-55c5c5e586fc","keyframes":{"transform":["translate3d(-106.0274%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fd5aaa02-1c89-4e4f-a366-b1f41ed69bb5","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f8631330-ee5a-446f-abd6-3da8cf3d8bce","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-1f9ae4d1-e591-4773-be40-ab8eaf48146b","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1d14075c-8456-4934-bcc9-4bd033a974c1","keyframes":{"transform":["translate3d(0px, 144.09540%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d7b5a7b5-56b4-4c58-8287-42d6e40cba73","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9d444ac7-302d-4730-9675-165beb15dbfb","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

Embrace CASE Statements

[{"selector":"#anim-8606eea3-7564-4581-b0e1-55f05528ec3e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a8ee6799-45f6-4727-9432-03bda9e43c81","keyframes":{"transform":["translate3d(0px, 150.76543%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d8688a1a-887e-4923-b1b4-659fc9cedf44","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-37e836eb-0eea-45b1-8bcd-e5495439d50d","keyframes":{"transform":["translate3d(-122.41993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4546f49b-1938-417e-99da-73477b3df882","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f6dd52e2-1fed-485a-b67b-3ac9663b08e5","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-b0fc95e7-aa37-4fe5-8da2-d01a91c3133c","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a2c1d204-e0c3-4154-8b8e-e4fc348917f4","keyframes":{"transform":["translate3d(0px, 170.48798%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c423ce60-86b0-4da8-bc3a-11de905fb63a","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-afdc8ecd-a31e-43c8-9622-56e817a538ce","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

Subqueries for the Win

[{"selector":"#anim-4d15d7c8-a094-49e8-82da-a9502be05bc2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fb3c243e-de18-4070-9c28-0adbf50f828b","keyframes":{"transform":["translate3d(0px, 147.86325%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-610ccb34-66a5-4742-a67a-d332778c7136","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b3a9c3ba-4df1-4bf3-ac3f-d1d634f78379","keyframes":{"transform":["translate3d(-122.41993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0e70ecb3-1a25-4e8b-9d90-70b58ea42cfc","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-756bd56b-e061-4d01-96c8-83e9faa3123e","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-b96657e2-1143-4be6-a6a4-3ed690c4e7dd","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d0a11caa-f863-436f-ab21-53282538ef62","keyframes":{"transform":["translate3d(0px, 155.55555%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-289a119e-e23d-4f6e-a758-aafd782e432b","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4d6e6fe0-e06e-4643-b87c-0eef0476d18b","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

LIKE Operator Magic

[{"selector":"#anim-6c0631ce-654d-47b8-9312-47d1396ed18b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-24a558b3-c3a9-4f91-b2ff-298c0e36bbfc","keyframes":{"transform":["translate3d(0px, 160.18521%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1988213e-cf55-4f22-adcb-e2f7df65c118","keyframes":{"opacity":[0,1]},"delay":200,"duration":1222,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0a60f124-af24-476b-b2ff-acb8d354b761","keyframes":{"transform":["translate3d(-122.41993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a76e350d-561e-485c-b160-3d5d48d78922","keyframes":{"opacity":[0,1]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a0a33114-685a-4d00-815e-1985e8010a10","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":150,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-6ff3b567-e29d-4b46-b1a4-9f91fdbe8843","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-747e9e78-df5f-4d72-b5df-59d7d733c0dc","keyframes":{"transform":["translate3d(0px, 159.92235%, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4fa95618-eea3-49f8-b8e7-28e792911ccb","keyframes":{"opacity":[0,1]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-24f8e1d8-391e-4244-a53c-568385123bad","keyframes":{"transform":["translate3d(0px, 208.95070%, 0)","translate3d(0px, 0px, 0)"]},"delay":500,"duration":900,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Read More

SQL Tips and Tricks for Data Analysts

Master SQL Alchemy

Unify Python & SQL. Write cleaner, more concise queries. Boost your Data Analysis workflow.

Window Functions Unleashed

Unlock ROW_NUMBER(), LAG(), and LEAD() for powerful data transformations within a single query.

Common Table Expressions (CTEs): Your Friend

Simplify complex queries with temporary result sets. Organize & reuse logic for readability.

JOIN Mastery

Level up from basic joins. Explore INNER, LEFT, RIGHT, FULL OUTER for versatile data relationships.

Embrace CASE Statements

Simplify conditional logic within queries. Write cleaner, more readable code for data filtering.

Subqueries for the Win

Solve complex problems with nested queries. Leverage subqueries to filter, aggregate, and transform data.

LIKE Operator Magic

Use wildcards & patterns for flexible text searches. Fine-tune your data filtering for specific results.