Day 50/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Identified invoices that contain more than one track from the same album. #LearnInPublic Finally completed my course and got completion certificate.
Day 49/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Used CASE and SUM function to calculate the count of different values in a single column. #LearnInPublic
Day 48/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Obtained the longest tracks name with genre id. #LearnInPublic
Day 47/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Used Aggregate function to obtain the recent Invoice of the Customer. #LearnInPublic
Day 46/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Over and Partition clause to find the running total of Invoice table. #LearnInPublic
Day 45/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Combined two tables with their distinct values using UNION keyword. #LearnInPublic
Day 44/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Used UNION ALL keyword and Aliases to combine the table. #LearnInPublic
Day 43/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Retrieved provinces that have more patients identified as 'M' than 'F'. Used CASE, SUM aggregate function. #LearnInPublic
Day 42/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Order the given column with specific start. PS: Try to solve the different case statement questions! #LearnInPublic
Day 41/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ How to use LAG function? PS: Retrieve the admission date, number of admissions per day, and the change in admission count compared to the previous day from the admissions table. 🎉🔍 #LearnInPublic
Day 40/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Obtained the total cost of Insurance using CASE and SUM aggregate function. PS: Replace the Columns and observe the corresponding output! 🎉🔍 #LearnInPublic
Day 39/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Changed the numeric value to string for particular range using CASE expression. PS: Don't forget to give the single quotes for the string! 🎉🔍 #LearnInPublic
Day 38/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Calculated the number of patients for a particular doctor using the COUNT function and JOIN for combining tables. PS: Try to use different JOINs and observe the corresponding output! 🎉🔍 #LearnInPublic
📊 Day 37/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Retrieved the values from table that doesn't exist in another table used NOT IN clause and subqueries. PS: Explore the different way of solving query ! 🎉🔍 #LearnInPublic
📊 Day 36/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Calculated track durations, merged tables, and sorted by playlist ID. PS: Explore the different JOINs and use them with multiple tables! 🎉🔍📚 #LearnInPublic
📊 Day 35/50 Days of SQL #codedamn #SQL Today’s Learning: ✅ Used LEFT JOIN and IS NULL keyword. PS: Try to solve query without using JOINs! 🎉🔍📚 #LearnInPublic
📊 Day 34/50 Days of SQL #codedamn #SQL Today’s Learning: ✅Leveraged subqueries and aggregate functions within the main query. PS: Keep Exploring and Mastering SQL! 🎉🔍📚 #LearnInPublic
📊 Day 33/50 Days of SQL #codedamn #SQL Today's Learning: ✅ Mastering JOINs and replacing abbreviations PS: Keep practicing for Mastering JOINs! #LearnInPublic
📊 Day 32/50 Days of SQL #codedamn #SQL Today's Learning: ✅ Used AVG aggregate function, Mastering the JOIN clause PS: Try to use different JOINs and obverse the corresponding result! #LearnInPublic
Day 31/50 Days of SQL #codedamn #SQL 📊 Today's Learning: ✅ Counting albums associated with each artist. PS: Try to work with different queries with different schemas! #LearnInPublic
United States Trends
- 1. #FinallyOverIt 5,269 posts
- 2. #TalusLabs N/A
- 3. Summer Walker 16.8K posts
- 4. 5sos 21.6K posts
- 5. #criticalrolespoilers 4,090 posts
- 6. Justin Fields 9,987 posts
- 7. Jets 69K posts
- 8. #GOAI 3,139 posts
- 9. Jalen Johnson 8,700 posts
- 10. Patriots 152K posts
- 11. Go Girl 26.1K posts
- 12. Wale 33.5K posts
- 13. 1-800 Heartbreak 1,368 posts
- 14. #BlackOps7 16K posts
- 15. Drake Maye 21.2K posts
- 16. Judge 205K posts
- 17. Bihar 234K posts
- 18. Robbed You 4,042 posts
- 19. Domain For Sale 12.2K posts
- 20. Disc 2 1,010 posts
Something went wrong.
Something went wrong.