Arama Sonuçları: "#PracticeSQL"

17 sonuç
Akpan Abasikpongke
Akpan Abasikpongke@abbytechkie·
SELECT product, COUNT(*) AS total_orders FROM orders GROUP BY product HAVING COUNT(*) > 10; -- filter groups after counting ✍️HAVING = “Filter the grouped data after aggregating.” #practicesql #excel #day4
English
0
0
0
34
LearnSQL.com
LearnSQL.com@LearnSQLcom·
Advance your SQL skills with our beginner-friendly guide: 15 exercises on queries, JOINs, sorting, grouping, NULL handling, and aggregation. Start now to unlock career growth and master essential data management techniques ➡️ bit.ly/49jkivG #SQLExercises #PracticeSQL
English
0
0
3
57
The SQL Tribe
The SQL Tribe@thesql_tribe·
💙PRACTICE SQL💙 Write a SQL query to find the average price of products in the Kitchen category using the table ‘Products’ below. #thesqltribe #practiceSQL
The SQL Tribe tweet media
English
3
3
11
1.2K
The SQL Tribe
The SQL Tribe@thesql_tribe·
Let's start the week practicing SQL😊. Using the tables below, write a SQL query to retrieve the students who enrolled in the ‘Data Structures’ course. Tell us your answer in the comments👇🏾 #thesqltribe #practicesql
The SQL Tribe tweet media
English
5
4
10
1.4K
The SQL Tribe
The SQL Tribe@thesql_tribe·
What is the meaning of LIKE ‘%0%0%’? a) Feature begins with two 0’s b) Feature ends with two 0’s c) Feature has more than two 0’s d) Feature has two 0’s in it, at any position #thesqltribe #learnsql #practicesql
English
6
1
8
1.4K
The SQL Tribe
The SQL Tribe@thesql_tribe·
💙PRACTICE SQL💙 Using the tables below, write a query to retrieve the details of employees who are in the 'Engineering' department. #thesqltribe #practicesql
The SQL Tribe tweet media
English
2
2
8
1.1K
The SQL Tribe
The SQL Tribe@thesql_tribe·
Let's start the week practicing SQL😊. Using the table, write a query to update the salary of Emily Brown to $75000. #thesqltribe #practicesql
The SQL Tribe tweet media
English
3
0
3
2.1K
The SQL Tribe
The SQL Tribe@thesql_tribe·
💙Practice Question💙 Using the table below, write a query to determine the average number of days between consecutive orders for each customer. Join the community using the link below to access daily SQL practice questions. thesqltribe.org/community/ #thesqltribe #practicesql
The SQL Tribe tweet media
English
2
2
14
1.5K
The SQL Tribe
The SQL Tribe@thesql_tribe·
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
The SQL Tribe tweet media
English
7
2
23
3.2K
The SQL Tribe
The SQL Tribe@thesql_tribe·
The table Nobel shows the subject and the award winners for a particular period of time. Can you write a query that would return the year when neither a Physics nor Chemistry award was given. #practicesql #SQL
The SQL Tribe tweet media
English
14
0
12
0