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
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”.
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
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
@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.
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
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.
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 👇🏾
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 💙
VARCHAR is commonly used in SQL when the length of the data in a column varies considerably.
Can you tell the difference between CHAR and VARCHAR?
#learnsql
#sqltribe
#varchar
#data
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 -
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.
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.
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
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?
@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
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
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 ?
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
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.
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 👇🏾
❤️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
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.
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.✨
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 💙
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".
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
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
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
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
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
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 -
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
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
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 💙
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
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?
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
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 💙
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
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
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
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
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
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
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
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
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
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
💙Practice Question 💙
Using the tables below, write an SQL query to find the products that have been ordered the most.
.
.
#thesqltribe
#learnsql
#practicesql
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
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
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 🚀
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.
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
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 💙
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✨
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 💙
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 💜
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✨
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 -
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
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
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
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.
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!
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✨
The table Employee contains the details of staff in a particular company.
Can you write a query that will return the details of employees that were employed in the 80s and have names with the character set ‘AR’ together using the table Employee below?
#learnsql
#sql
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-
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-
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
The table, Uber_advertising, shows different advertising channels Uber used to acquire more customers and the costs in 2018 and 2019.
Write a query that will return the year that Uber acquired more than 1800 customers through advertising using celebrities.
#SQL
#sqlquery