#30dayssqlchallenge résultats de recherche
🚀 Day 28 of my #30DaysSQLChallenge – Analytics SQL: Time Series Analysis Time series analysis isn’t just for data science tools like Python or R — you can do a lot directly in SQL! I’ve practiced different SQL techniques that help uncover trends and insights over time.
Foundations of SQL Day 5: Sorting Results Question: List all employees ordered by HireDate descending. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 1: Basic SELECT Statements Question: Retrieve all columns and rows from the Employees table. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 4: Using Comparison Operators Question: Retrieve employees with a salary greater than 50,000. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 2: Selecting Specific Columns Question: Select the FirstName, LastName, and Salary of all employees. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Day 23 of my #30DaysSQLChallenge – Transactions & Constraints Today’s topic is too broad to cover in just one sitting. So I’ll be dividing it into two parts for better clarity: Part 1 (Today): Understanding what Transactions and Constraints are.
🚀 Day 22 of my #30DaysSQLChallenge Today, I focused on Joins and Views in SQL. While joins are powerful for combining data across multiple tables, I found views especially interesting: 🔹 A view is like a virtual table that stores a query for easy reuse.
Foundations of SQL Day 7: Review and Practice Task: Review the week's concepts by redoing previous queries and experimenting with different departments or salary ranges. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 3: Filtering Rows with WHERE Question: Find all employees in the 'IT' department. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 6: Limiting Results Question: Display the top 5 highest-paid employees. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Week 2: Intermediate SQL Concepts Day 8: Aggregation Functions Question: Calculate the average salary of all employees @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
🚀 Day 17 of my #30DaysSQLChallenge 🚀 Today’s focus: Common Table Expressions (CTEs) A CTE is a temporary named result set that exists only within the query that follows it. Working with CTEs today helped me break complex queries into smaller steps instead
Something went wrong.
Something went wrong.
United States Trends
- 1. #MerryChristmasJustin 11.7K posts
- 2. FOMC 40.5K posts
- 3. #wednesdaymotivation 3,726 posts
- 4. Met Gala 61.9K posts
- 5. Rayman 2 2,111 posts
- 6. Waffle House 4,821 posts
- 7. #HumanRightsDay 33.5K posts
- 8. Hump Day 16.6K posts
- 9. Good Wednesday 38K posts
- 10. Act III 3,212 posts
- 11. Oslo 289K posts
- 12. #Wednesdayvibe 2,720 posts
- 13. Tonic Trouble 1,465 posts
- 14. Zendaya 39.3K posts
- 15. Sophie Kinsella 2,981 posts
- 16. María Corina Machado 286K posts
- 17. María Corina Machado 286K posts
- 18. #NXXT_GridReform N/A
- 19. Electrician 2,351 posts
- 20. Powell 40.4K posts