Top Tweets for #Techavilly
Let's end this debate, once and for all.
Is tomato a vegetable or fruit?
What's your final answer?
#techavilly #triviasciencequestions#funsaturday
Thank you so much for reading.
Hope you learnt something. I'm still learning this thing called Excel ooπ
Can't wait to share my Day 4 task submission with you all.
Excel to the worldπ₯³
#Excel #Techavilly #Excelchallengeπ₯
Day 30 (The End) π₯°
I selected the employees' first name, last name, department, and salary.
I used the DENSE RANK function to rank each employee's salary in descending order and PARTITION BY the department.
#30daysqlchallenge #techavilly #SQL #mysql
Day 29
I selected the job title and department.
I added a subquery in the WHERE clause to filter the result to only the job title and department with the highest Salary.
- The manager title in the HR department has the highest salary
#30daysqlchallenge #techavilly #mysql
Day 29
I selected the job title and department.
I added a subquery in the WHERE clause to filter the result to only the job title and department with the highest Salary.
- The manager title in the HR department has the highest salary
#30daysqlchallenge #techavilly #mysql
Bonus Question
I used two methods
1. The Limit and Offset method: used OFFSET to skip the first two sales and LIMIT it to one output
2. The Window function and Subquery: I used subquery to find sales and the ROW_NUMBER of each sale then selected the sales where the row_num is 3
Day 23
I selected the state, and used the DATEDIFF to calculate the number of days between the order date and the ship date.
I then found the average number of days it takes to deliver to each state.
#30daysqlchallenge #techavilly #mysql
Day 23
I selected the state, and used the DATEDIFF to calculate the number of days between the order date and the ship date.
I then found the average number of days it takes to deliver to each state.
#30daysqlchallenge #techavilly #mysql
Day 23
This question is on the stock market. I first calculated the daily changes in open and closed share prices.
Then I used the MIN and MAX functions to get the highest_daily decrease and highest daily increase.
#30daysqlchallenge #techavilly #mysql
Day 23
This question is on the stock market. I first calculated the daily changes in open and closed share prices.
Then I used the MIN and MAX functions to get the highest_daily decrease and highest daily increase.
#30daysqlchallenge #techavilly #mysql
Day 22
I selected the first name, last name, and salary columns.
I used the window function to calculate the company's average salary and then find the difference between each employee's salary and the company's average salary.
#30daysqlchallenge #techavilly #mysql
Day 22
I selected the first name, last name, and salary columns.
I used the window function to calculate the company's average salary and then find the difference between each employee's salary and the company's average salary.
#30daysqlchallenge #techavilly #mysql
Day 18
The duration is in weeks, so I divided by 52 to convert to years. I then used the AVG function to find the average years of customers' employment.
I filtered it to show the result for only customers in management positions.
#30daysqlchallenge #techavilly #mysql
Day 18
The duration is in weeks, so I divided by 52 to convert to years. I then used the AVG function to find the average years of customers' employment.
I filtered it to show the result for only customers in management positions.
#30daysqlchallenge #techavilly #mysql
Day 16
Another query that would have return the same output is CTEs, but no stress οΏ½οΏ½οΏ½οΏ½π
#techavilly #30daySqlchallenge
Day 15
I used CTE to find the number of customers who are divorced and have a balance of more than 2,000,
then, I divided it by the total number of customers and multiplied by 100 to find the percentage of divorced customers.
#30daysqlchallenge #techavilly #mysql
Day 15
I used CTE to find the number of customers who are divorced and have a balance of more than 2,000,
then, I divided it by the total number of customers and multiplied by 100 to find the percentage of divorced customers.
#30daysqlchallenge #techavilly #mysql
Day 12
I selected the Segment, summed the sales column, summed the profit column, calculated the profit margin generated by each segment, and ordered the profit margin column in descending order.
#30daysqlchallenge #techavilly #mysql
Day 12
I selected the Segment, summed the sales column, summed the profit column, calculated the profit margin generated by each segment, and ordered the profit margin column in descending order.
#30daysqlchallenge #techavilly #mysql
Day 11
I used the Year function to extract the year from the order date, Sum the sales column, filtered the query to return only sales for Phones, and ordered the total_sales column in descending order.
#30daysqlchallenge #techavilly #sql
Day 11
I used the Year function to extract the year from the order date, Sum the sales column, filtered the query to return only sales for Phones, and ordered the total_sales column in descending order.
#30daysqlchallenge #techavilly #sql
Day 10
I selected the sub-category and the total sales generated by each of them, I ordered the total sales from the highest to the lowest to be able to see the sub-category that sells the most.
#30daysqlchallenge #techavilly
Day 10
I selected the sub-category and the total sales generated by each of them, I ordered the total sales from the highest to the lowest to be able to see the sub-category that sells the most.
#30daysqlchallenge #techavilly
I officially joined the #30daysqlchallenge organized by #techavilly which involves analyzing business questions with SQL. It's Day 9 of the challenge. Below is today's task and my solution.
I officially joined the #30daysqlchallenge organized by #techavilly which involves analyzing business questions with SQL. It's Day 9 of the challenge. Below is today's task and my solution.
The #30daySQLchallenge by #techavilly officially started on 09-10-2023 (Monday). Here are the questions and the expected results for Day 1 and Day 2.
It was indeed a full class. If you missed this training, please stay on our page for updates on the next training. #techavilly
Last Seen Hashtags on Sotwe
stwbinal
Seen from Indonesia
ΰΈ£ΰΈ±ΰΈΰΈΰΈ²ΰΈΰΈͺΰΈ‘ΰΈΈΰΈΰΈ£ΰΈΰΈ£ΰΈ²ΰΈΰΈ²ΰΈ£
Seen from Thailand
monkeyappwins
Seen from France
Louisvangaalarmy
Seen from United States
WomensRightsAreHumanRights
Seen from United States
omegle
Seen from United States
ΨͺΨ§ΩΨ¬Ω
Teenage() +filter:native_video
Seen from Brazil
Cockvore
Seen from Belgium
OutOfTheBlueMonday
Seen from Indonesia
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.9M followers
Barack Obama
@barackobama
119.2M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Cristiano Ronaldo
@cristiano
111.6M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
97.9M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
91.1M followers
KATY PERRY
@katyperry
88.2M followers
Taylor Swift
@taylorswift13
82M followers
Lady Gaga
@ladygaga
73.6M followers
Virat Kohli
@imvkohli
70.7M followers
Kim Kardashian
@kimkardashian
70M followers
YouTube
@youtube
68.7M followers
Bill Gates
@billgates
64.2M followers
Neymar Jr
@neymarjr
63.6M followers
The Ellen Show
@theellenshow
62.4M followers
CNN
@cnn
61.8M followers
Selena Gomez
@selenagomez
61.3M followers
X
@x
60.8M followers