Subham chαnd 👉😁👈
Subham chαnd 👉😁👈 @subhamchand04 ·
100% off Udemy course coupon Learn SQL with 100 Coding Exercises Master SQL: Enhance Your Skills with 100 Hands-On Coding Queries in 100 Days - Take the Challenge! korshub.com/courses/learn-… #udemy #udemyfreecoupon #SQLCoding #LearnSQL #SQLChallenges #CodingExercises #korshub
100% off coupon for Learn SQL with 100 Coding Exercises January 2026 | Korshub

Master SQL: Enhance Your Skills with 100 Hands-On Coding Queries in 100 Days - Take the Challenge!

From korshub.com
26
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_18 SELECT salesPerson, MIN(amount) AS "Average sales amount" FROM salestbl GROUP BY salesPerson HAVING MIN(amount) > 5000 HAVING clause in SQL is used to apply a filter condition to groups of rows created by the GROUP BY clause #share #learn #collaborate
20
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_17 SELECT department, COUNT(empID) FROM employee GROUP BY department GROUP BY in SQL is used to group rows based on one or more columns *In the example above It helps to determine the count of employees in each department.* #learn #share #collaborate
21
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_15 SELECT name FROM country WHERE name LIKE ‘a%’ LIKE operator is used to search for a specified pattern in a column. It is often used with the ‘%’ wildcard symbol. *In the example above all country names that start with the letter ‘a’ will be retrieved*
1
24
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_14 SELECT MIN(amount) FROM salesTbl Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg) *MIN() function used above is to find the minimum sales amount* #learn #share #collaborate
7
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_12 SELECT COUNT(empID) FROM employee Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg) *COUNT() functions used above finds the count of employees*
14
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_11 SELECT AVG(amount) FROM salestbl Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg) *Average (AVG) functions used to find the average amount in the sales table*
12
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_10 SELECT SUM(amount) FROM salestbl Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg) *SUM functions used above sums values*
15
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_9 SELECT fname, lname, contact FROM employeeTbl ORDER BY city DESC In the example the DESC keyword is used to order records from Z-A based on the city column
13
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_7 *SELECT * FROM employeeTbl WHERE city = “Accra” AND city = “Kumasi” In this example WHERE clause is combined with the comparison operator (=) and the logical operator (AND) to select employees in the city Accra and Kumasi
13
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_6 *SELECT * FROM employeeTbl WHERE city = “Accra” OR city = “Kumasi” In this example WHERE clause is combined with the comparison operator (=) and the logical operator (OR) to select employees in the city Accra or Kumasi
12
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_2 *SELECT fname, lname, gender FROM table_name* This selects all rows based on the fname, lname and gender columns from a table in a database
23
GIT Tech Hub
GIT Tech Hub @gittechhub ·
#SQLCoding-ton_Day_3 *SELECT DISTINCT city FROM employeeTbl* The SELECT DISTINCT statement is used to return only distinct (different) values
15