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
ensestpaylasΔ±m
Seen from Netherlands
θ’«ε¨ζΆε
₯η±»ε
Seen from United States
azgΔ±
Seen from United States
countryhumansnsfw
Seen from United States
bbw chubby shemale
Seen from France
brosis()******** filter:videos
Seen from United States
mgai()***************************************** filter:videos min_likes:1
Seen from Brazil
ΰΈ«ΰΉΰΈΰΈΰΈΰΉΰΈ³ΰΈ«ΰΉΰΈ²ΰΈ
Seen from Thailand
taksimgay
Seen from Turkey
VolpeHomerun
Seen from United States
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