The SQL Tribe
@thesql_tribe
Followers
9,281
Following
10
Media
404
Statuses
1,433
A community to connect and learn from other SQL professionals.
Lagos, Nigeria
Joined April 2021
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Errejón
• 268989 Tweets
Fenerbahçe
• 135532 Tweets
Beşiktaş
• 124192 Tweets
Mario
• 112230 Tweets
Manchester United
• 74414 Tweets
Lyon
• 53480 Tweets
Mourinho
• 51640 Tweets
Onana
• 36952 Tweets
Antony
• 36652 Tweets
Ten Hag
• 36630 Tweets
McConnell
• 32341 Tweets
Europa League
• 30688 Tweets
Mitch
• 27733 Tweets
#OLvBJK
• 27400 Tweets
Amad
• 22856 Tweets
السوبر المصري
• 20785 Tweets
Menendez
• 20775 Tweets
Gedson
• 19060 Tweets
#GHGala8
• 17915 Tweets
#FBvMUN
• 17689 Tweets
Mazraoui
• 17524 Tweets
Mert
• 14772 Tweets
Rashford
• 14378 Tweets
Ugarte
• 14082 Tweets
Zirkzee
• 13600 Tweets
連載マンガ
• 13303 Tweets
Garnacho
• 12944 Tweets
Ersin
• 11281 Tweets
Semih
• 11189 Tweets
Maguila
• 10948 Tweets
İrfan
• 10947 Tweets
Pinned Tweet
SQL RIDDLE💙
What did the one SQL table say to the other SQL table at the bar this past Friday night?
52
14
89
Write an SQL query to find the customer who has placed the largest total order amount. Return the customer's full name and the total order amount.
46
72
334
SQL handles dates using different formats. Understanding how it works is very important for data management.
Here are some examples of how dates are used in a query.
Share an example of how you have used Dates in SQL👇🏾.
#SQL
#data
#DataScience
3
40
230
Using the table Orders, write a query that will return the customerid, order_date, and item values for any items in the item column that start with the letter “S”.
50
26
185
Views are a powerful feature in SQL databases and are commonly used for various purposes, such as providing simplified access to data, enhancing security, and improving query efficiency.
Share this with someone who would find this helpful❤️.
#sqlviews
#datascience
#data
2
22
136
Write an SQL query to find the products in the "Electronics" category that have a price greater than the average price of all products in the "Electronics" category.
#SQL
#queryquestion
19
25
135
@Yinkaoke
is an astute Data and Business Analyst with core competencies in analyzing and interpreting business data using various technology and software. She works at Ingressive Capital, a Venture Capital firm(VC) as a Data Analyst.
5
16
120
The GROUP BY statement in SQL is used for organizing similar data into groups.
Check out the next slides to see examples on how to correctly use the GROUP BY statement in a query.
Follow us for more contents like this to learn more about SQL.
#sql
#programmer
#dataanalytics
0
24
115
Have you been looking to learn SQL for FREE?
Check out this websites for free courses.
#sql
#freecourses
#DataAnalytics
2
31
90
The HAVING clause in SQL is used in database systems to fetch the data/values from the groups according to the given condition.
It is generally used after using a GROUP BY clause.
Check out how it is used correctly in a query.
3
18
80
Esther Oyenekan is an aspiring Data Analyst. She started her data journey in April 2021. She improved herself by watching YouTube videos and taking online courses.
Read more about Esther by clicking the link below 👇🏾
3
11
71
From the tables below, write a SQL query to identify those patients whose primary care is provided by a physician who is not the head of any department. Return Patient name as "Patient", Physician Name as "Primary care Physician".
RT and share with a friend 💙
4
19
65
Different people when typing commands😂.
Which one are you?
31
16
57
Join
@AbbyViz
and
@thesqlbabe
as we talk about Abby’s incredible journey to becoming Africa’s first Tableau Zen Master. This is going to be an enlightening conversation and we’re super excited about it. Get your tickets here -
1
23
53
QUESTION OF THE DAY
Which statement is false for the ORDER BY statement?
A. Requires a ASC or DESC keyword explicitly to sort the result set.
B. Can sort based on multiple columns.
C. Sorts the result set in descending order using DESC keyword.
D. None of the above.
66
2
51
Based on the tables below, select the customer_id and last_name from the Customers table and select the order_date from the Orders table where there is a matching customer_id value in both the customers and orders tables.
Order the results by customer_id in descending order.
21
6
50
SQL tutorials can make you feel like a superstar but SQL interviews can really be a humbling experience.
Who else has experienced this? 😂😂
CC:
@NickSinghTech
6
12
48
SQL RIDDLE💙
I am a command used to combine rows from different tables based on a related column. I can bring together data from multiple sources into a single result set.
What am I?
43
6
46
@zizzy_data
is a data scientist with an affinity for data visualisation and a two-time Tableau Public ambassador. Intersecting data, design, and user experience, Zainab likes to tell stories with data and convey insights in a visually impactful way.
#womenindata
#breakthebias
2
10
41
Using the table EmployeeDetails and EmployeeSalary, write an SQL query to uppercase the name of the employee and lowercase the city values using the table below.
Source: ArtOfTesting
Follow us for more contents like this.
#sql
#sqlserver
#programming
#developer
#programmer
6
11
40
Becoming a data analyst is all about taking the right steps in the right direction.
Here’s
@andrewzhan
journey to becoming a data analyst.
#dataanalytics
#tech
#SQL
0
14
39
Here are some data analyst roles you can check out if you’re looking to get into the data space:
-Business analyst
-Product analyst
-Business Intelligence Analyst
-Data Specialist
-Analytics Consultant
-Operations Analyst
- Analytics Specialist
Which other did we leave out ?
0
16
39
Write a query that selects the item name and the name of its seller for each item that belongs to a seller with a rating greater than 4.
Please note: The query should return the name of the item as the first column and name of the seller as the second column.
#sql
#thesqltribe
13
6
37
Using table Customers and Item_ordered, write a query to determine which items were ordered by each of the customers in the customers table.
Follow us for more contents like this.
#SQL
#programming
#developer
#coding
#mysql
#sqldeveloper
#dataanalytics
#sqlqueries
15
7
37
Astract9 is working on launching a Web Application that will be monitoring the realtime results of the 2023 General Elections and is in need of Data Analysts/Clerks who will be able to upload, compare and update election results in realtime.
3
32
35
Meet Oluwafisayomi, a Data Analyst and also a small business owner.
We asked
@_fisayo__
what she would do if she won a million dollars in the lottery.
Do you want to know what she said? 😄
Click the link below to read the blog post about Fisayo 👇🏾
6
9
36
❤️PRACTICE QUESTION ❤️
Using the tables below, write a SQL query to find the students who have the highest GPA in each course.
#learnsql
#sql
#data
#DataAnalytics
5
7
35
We are excited to announce the next SQL class is starting April 23rd💃.
In 4 weeks, you'll learn the A-Z introduction to SQL, work on well-guided assignments, get access to essential resources to accelerate your learning of SQL and a certificate to wrap it up.
2
26
32
PRACTICE QUESTION 📝
Using the tables below, write an SQL query to list the customers who have not placed any orders.
#sql
#DataAnalytics
#DataScience
11
11
31
💙Practice Question💙
Using the tables below, write a SQL query to get the number of salesmen in each city who have a commission greater than 0.12.
9
6
31
From the tables below, write a SQL query to find which departments have more than two employees.
Join the community via the link below to learn more about SQL with daily SQL practice questions.✨
7
4
32
Quiz of the day!
How well do you know your SQL FUNCTIONS?
Join the community via the link below to learn more about SQL with daily SQL practice questions.
#sql
#programming
#developer
#programmer
#mysql
#dataanalytics
31
4
31
QUESTION OF THE DAY 💙
Using the tables below, write an SQL query to display the group sales by different age groups of customers. Below 30, Between 30 to 39, and 40 and above.
Join the community via the link below for daily SQL practice questions 💙
9
12
31
Meet one of our panelists -
@AdoraNwodo
, a Software Engineer at Microsoft. She is currently building Mixed Reality on the Cloud at Microsoft. She is also the Author of the popular book "Cloud Engineering for Beginners".
1
15
30
SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.
Tell us about the type of join you'd like us to talk about in the comment session👇🏾
#thesqltribe
#sqljoins
#joins
#sql
9
7
30
What advice would you give to someone Just starting out with SQL?
Let’s hear it.
10
5
31
Using Table Movies, can you write a query that will return the names of movies that were released after 1995 ?
Source: SQLBolt
27
3
29
Looking for job opportunities to advance your career? We’ve got you covered! We’ve perfectly curated a list of job openings from a range of companies to fit your unique talent.
RT and share with a friend 💙
1. Digital Analyst at Shell
1
14
26
The IN and NOT IN operators are used to filter datasets based on specific conditions, which makes your queries more efficient and easy to read.
See examples of how they are used differently in a query in the second slide😊.
#thesqltribe
#learnsql
#sqloperators
0
7
29
QUESTION OF THE DAY 💙
Based on the suppliers table below, select the unique city values that reside in the state of California and order the results in descending order by city
Let us know your answer in the comment section
27
7
26
Using the "QuarterlyRevenue" table, write a SQL query to pivot the data to show the total revenue for each region in each quarter for the years 2022 and 2023.
Name the resulting table "Pivoted_Revenue."
#SQL
#data
#datascience
5
0
28
If you are new to SQL and looking for where to learn for free, check out these website below 👇🏾
1. SQLZoo-
2. Codecademy-
3. Stanford University -
4. Khan Academy -
1
13
29
Welcome to the month of February!
Wishing you a month filled with love, peace and productivity✨.
0
2
27
SQL constraints are used to restrict the type of data that can be inserted, updated or deleted from a table and also to ensure that the data meets certain requirements. They help to ensure data reliability.
Source: W3school
Follow us to learn more about SQL✨
#sql
#sqlserver
0
5
25
Table ‘Salary’ contains the details of Employees in a company.
Can you write a SQL query to fetch all the Employee details who joined in the Year 2015 from the table?
Source: Art of Testing
#thesqltribe
#sqlqueries
26
2
24
0
10
25
Using the tables below, write a query to retrieve the list of patients assigned to a specific doctor and get the number of appointments scheduled for each day of the week.
Join the community via the link below for daily SQL practice questions 💙
3
3
26
SQL Aliases helps to simplify your SQL queries by assigning temporary names to tables and columns.
Join TheSQLTribe community to learn more about SQL.
0
5
26
Have you tried extracting some characters from a string while using SQL?
Well, here is the correct function to use😊
Can you tell what query will return the 3 middle letters in ‘Nigeria’👇?
#learnsql
#sqltribe
#sqlsubstring
#sqlfunctions
4
4
25
Using Table Customer, can you write a query that will return 50% record from the table?
Source: FreeCodeCamp
#thesqltribe
#learnsql
#sql
5
10
25
Using the table Movies, what are the movies to be released in 2010 or have a rating higher than 9?
Follow us for more contents like this.
#sq
|
#programming
#html
#database
#sqlserver
#coding
#developer
#programmer
13
10
25
SQL has a lot of functions and queries. Here are some of the rarely used functions:
- SIGN ()
- FLOOR ()
- IFF ()
- LEAD ()
- LAG ()
- CEILING ()
Which one of them have you used?
13
6
24
Can you answer this question?
Using the tables below, write a query to retrieve the OrderID and OrderDate of orders placed by customers who ordered at least one "Laptop."
#SQL
#practiceSQL
7
2
24
QUESTION OF THE DAY
Using the tables below, which item was purchased first by the customer after they became a member?
Tell us your answer in the comment section. RT and share with a friend 💙
8
9
24
Have you tried using the COUNT, SUM, and AVG functions in SQL.
Check the second image to see how they are used correctly in a query.
Join the community through the link below to learn more.
#learnsql
#thesqltribe
#sqlfunctions
0
5
23
Looking for job opportunities to advance your career? We got you covered! We’ve curated a list of job openings from a range of companies to fit your unique talent.
RT and share with a friend 💙
1. Junior Data Engineer - QuantumBlack, Al by McKinsey
2
11
21
We enjoyed every minute of the first panel session moderated by
@Kharis_nosa
. The conversation was about how you can use data as an impactful tool for delivering good work as a non-techie.
#dataguessconference2022
1
7
22
From the Employees and Job_history, write a SQL query to find employees who earn $12000 or more.
Join the community via the link below for daily SQL practice questions.
Source: W3resources
#sql
#practicesql
#learnsql
#data
#datascience
#dataanalytics
2
4
22
This week write it down!! your goals, tasks and activities. We know life can get hectic and consuming, but with a to-do list, you can take charge, stay organized and accountable! Writing down your tasks helps you prioritize and manage your time effectively. 🥂💙
Cc:
@peaceitimi
0
5
20
Have you ever wondered if it’s possible to change the cases of the characters in SQL? Well yes, the UPPER AND LOWER functions in SQL are used for that.
Check out the next slide to see how you can correctly use them in a query.
#sql
#sqlserver
#programming
#developer
#coding
0
10
20
Are you unsure of the courses to take to become a Data Analyst?
Here’s a list of places you can visit to get started;
- Google Data Analytics Course
- Coursera
- DataCamp
- YouTube
Let us know if you have any questions in the comment section 👇
#thesqltribe
#dataanalysis
2
7
19
The Inner Join in SQL which can also be referred to as Equijoin, is used to select records with matching values from tables.
Check out how it is used correctly, and let us know in the comment section 👇🏾if you have any question.
#sql
#thesqltribe
#sqljoins
#innerjoin
0
6
19
The Union operator combines the results of two or more queries and removes the duplicates.
Check out the second image to see how it is used correctly in a query.
#learnsql
#thesqltribe
#sql
#data
0
7
21
Today, we will learn about the Outer Join, one of the types of joins in SQL.
Check out the different types of Outer Joins, and let us know if you have any questions.
#sql
#thesqltribe
#joins
#outerjoin
0
4
20
Are you currently starting a new career or in the process of transitioning?
If your answer is yes, then you need to join a career-based community as the benefits are endless.
Check out the article via the link below
4
3
18
💙Practice Question 💙
Using the tables below, write an SQL query to find the products that have been ordered the most.
.
.
#thesqltribe
#learnsql
#practicesql
7
3
19
Using Table City, what query will return all columns for all China cities in the CITY table with populations larger than 30000?
The CountryCode for China is CN.
Source: HackerRank
22
0
20
The Group By statement is one of the most used SQL statement.
This is how it is used correctly.
Let us know👇🏾if you have any question.
#thesqltribe
#groupby
#learnsql
0
6
19
From the following tables below, write a query in SQL to find the movies in which one or more actors appeared in more than one film.
Let us know your answer in the comment section 🚀
4
10
18
We are excited to announce our latest partnership with all-in-one training platform,
@klas_hq
to provide amazing learning opportunities to the SQLTribe community members at an affordable rate.
1
5
20
SQL PRACTICE QUESTION💙
Using the tables below, list the names of customers who have placed orders on the same day as another customer.
Join the community via the link below for daily SQL practice questions 💙
RT and share
1
8
19
Happy new month 🥳
Embrace the opportunities this month brings. 🌟
0
3
18
Reliving the highlights from our last physical community hangout🥹!
We can’t wait to create more memories together! 💫
Do you see anyone familiar? Tag them below! 👇🏾
#community
#datacommunity
#datascience
#dataanalytics
#hangout
0
2
19
From the table below, write a SQL query to count the number of unavailable rooms. Return the count as "Number of unavailable rooms".
RT and share with a friend 💙
7
2
18
Based on the suppliers table below, select the unique city values that reside in the state of California and order the results in descending order by city.
Join the community via the link below to learn more about SQL with daily SQL practice questions✨
12
3
18
Hello everyone,
Are you looking for a career change or a fresh start? Don't miss out on these amazing job opportunities!
1. Data Analyst at Kuda
RT and share with a friend 💙
1
8
17
International women’s day is a reminder of the progress we’ve made and also of the work that still needs to be done.
Dear woman embrace yourself because you are unstoppable, you are powerful, you are strong!
Today let’s Embrace Equity! Happy International Women’s Day 💜
3
3
19
The LIMIT clause in SQL is used to limit the number of rows returned by a query and it typically appears at the end of a SELECT statement, after the WHERE and ORDER BY clauses.
Follow us to learn more about SQL✨
0
8
18
Write a query that will return the difference between the maximum and minimum populations in the table City as described in the image below 👇🏾.
8
2
18
To effectively run and grow a business, it’s vital that you know how to take advantage of the data you have at your disposal to make next-level business decisions. Come learn from these successful business owners. Get your tickets here -
0
4
17
Dates are one of the most used functions in SQL. Check out how it is used in a query in the second slide.
Tag someone who needs to see this.
#sql
#datascience
#datefunction
0
5
17
If you keep waiting for the perfect time, your dreams may never become your reality.
Start anyway and make your dreams come true💪.
#thesqltribe
#mondaymotivation
0
3
18
Growth is essential for every human, but remember to be patient with yourself just as you are gentle with a tender plant. Growth takes time.
Happy new week✨
#thesqltribe
#mondaymotivation
#growth
0
3
18
Using the table Claims, can you write a query that will count the numbers of claims submitted in December 2022 that are still pending?
A claim is pending when it has neither an acceptance nor rejection date.
8
2
16
Hi guys, our first community hangout of the year will hold this Sunday on the community discord💃.
If you are not yet on the discord channel, click the link in the bio to join the community.
See you there!
1
7
18
Be proud of who you are, accept yourself, and understand that “you” are your only competition.
The most important thing is to keep stepping up and strive to become better than you were yesterday.
Have a lovely week✨
0
5
18
10 different websites where you can practice SQL for free
Check them out 🔽
1. SQL Zoo -
2. HackerRank-
3. TechBeamers-
4. SQL Murder mystery-
5. SQLBolt-
1
11
16
Meet Abigeal Adenigbagbe, a Technical consultant based in Lagos, Nigeria.
In this edition,
@Richabbyy
tells us about her decision to transition to data analytics and her dream to get a data analyst role soon.
Read the full article here-
3
2
17
When learning a tech skill, it's easy to get lost and overwhelmed with all that's happening. That's why having a roadmap and joining a supportive community is crucial.🚀
Where are you in your roadmap journey? Share your experiences and let's inspire each other! 🌟
#TechSkills
1
8
17
