#30dayssqlchallenge результаты поиска
🚀 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.
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.
🚀 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
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
Foundations of SQL Day 6: Limiting Results Question: Display the top 5 highest-paid employees. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
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
Something went wrong.
Something went wrong.
United States Trends
- 1. Caleb 49K posts
- 2. Bears 66.2K posts
- 3. Packers 52K posts
- 4. #GoPackGo 9,882 posts
- 5. Nixon 12.1K posts
- 6. Notre Dame 160K posts
- 7. Ben Johnson 4,810 posts
- 8. DJ Moore 2,164 posts
- 9. Browns 74.9K posts
- 10. Raiders 32K posts
- 11. Shedeur 99.8K posts
- 12. Ravens 48.6K posts
- 13. Parsons 5,744 posts
- 14. Josh Jacobs 4,019 posts
- 15. Stefanski 29.5K posts
- 16. ESPN 117K posts
- 17. Jordan Love 11.4K posts
- 18. Green Bay 7,932 posts
- 19. Christian Watson 4,690 posts
- 20. Jeff Kent N/A