Top Tweets for #SQLcode
Ever revisited your SQL code and found yourself asking, βWhat was I trying to do here?β π
Thatβs where SQL comments become a powerful tool, not just for you, but for anyone reading your code.
#mysql #dataanalysis #Sqlcode #comment
Well this is fun and festive! Thanks to https://t.co/7buTdzcbmI for teaching us how to make a Christmas tree using SQL Code
#sqlcode #sql #sqlserver #mssql #learnsql.com #learnsql #sql #sqlsolutions #sqltraining #coding #codingchristmas #codechristmas #coderlife #programming
Day -19 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
Q : Is there any relationship between number of pizzas and how long it takes to prepare?
Day -18 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
Q : What was the average time in minutes it took for each runner to arrive at the Pizza Runner HQ to pickup the order?
Day -17 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
Case Study-2 Started
Runner and Customer Experience
Day -16 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
Case Study -2 : A part named "Pizza Metrics" completed.
Day -13 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge #weekend
Q: For each customer, how many delivered pizzas had at least 1 change and how many had no changes?
Day 9 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
Starting Case Study #2 - Pizza Runner. There are 6 tables in this case study. Data has been cleaned.
Please find below the data model
Day -9 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
# Bonus Q2: Solution
Case Study-1 Completed.
Please refer to this link for case study-1 : https://t.co/V1PPXwYZU4
Day -9 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity #8WeekSQLChallenge
BONUS QUESTION:
Create a data table that Denny and his team can use to quickly drive insights without needing to join the tables using SQL
Day -8 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity
Q9: In the first week after a customer joins the program (including their join date) they earn 2x points on all the items-- how many points do customer A and B ?
Day -7 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity
Q8: If each $1 spent equates to 10 points and sushi has a 2x points multiplier- how many points would each customer have?
Share your thoughts as well?
Day -6 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity
Q7: What is the total items and amount spent for each member before they became a member?
Day -6 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity
Q6: Which item was purchased just before the customer became a member?
Day -5 of #SQLCode π· #DataAnalysis #Programming #CodingChallenge #100DaysOfCode #CodeNewbie #CodingCommunity
Q: 5 Whichitem was purchased first by customer after they become member?
Last Seen Hashtags on Sotwe
mgai
Seen from Italy
CaughtOnCamera
Seen from Spain
SpringDay2years
Seen from United States
zerrinegeliler
Seen from Turkey
nsfw
Seen from United Kingdom
Shortstack
Seen from United States
IVE_AsiaTour
Seen from United States
unexpected ()*********************filter:videos
Seen from United States
ΰΈΰΈ§ΰΈ’ΰΈΰΈ‘ΰΉΰΈ²
Seen from Thailand
anxiouspandaa
Most Popular Users
Elon Musk 
@elonmusk
241M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.9M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.4M followers
Kim Kardashian
@kimkardashian
70.8M followers
YouTube
@youtube
68.7M followers
Neymar Jr
@neymarjr
66.4M followers
Bill Gates
@billgates
65.2M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.6M followers