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
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.2M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.6M followers
Cristiano Ronaldo
@cristiano
109M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.3M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.6M followers
KATY PERRY
@katyperry
86.8M followers
Taylor Swift
@taylorswift13
80.6M followers
Lady Gaga
@ladygaga
72.2M followers
Kim Kardashian
@kimkardashian
69.4M followers
YouTube
@youtube
68.6M followers
Virat Kohli
@imvkohli
68.6M followers
Bill Gates
@billgates
63.4M followers
The Ellen Show
@theellenshow
62.5M followers
CNN
@cnn
61.9M followers
Neymar Jr
@neymarjr
61.1M followers
X
@x
60.9M followers
Selena Gomez
@selenagomez
59.9M followers