SELECT CONCAT(Name, "(", LEFT(Occupation, 1), ")") FROM OCCUPATIONS ORDER BY Name; SELECT CONCAT("There are a total of ", COUNT(Occupation), " ", LCASE(Occupation) , "s.") FROM OCCUPATIONS GROUP BY Occupation ORDER BY COUNT(Occupation), Occupation;
Showing posts with label Advanced Select. Show all posts
Showing posts with label Advanced Select. Show all posts
31 January 2018
The PADS
My solution:
Type of Triangle
My solution:
SELECT IF(( A + B > C AND ABS(A - B) < C ) AND ( A + C > B AND ABS(A - C) < B ) AND ( B + C > A AND ABS(B - C) < A ), IF (A = B AND A = C AND B = C, "Equilateral", IF(A = B OR B = C OR A = C, "Isosceles", "Scalene")), "Not A Triangle") FROM TRIANGLES;
Subscribe to:
Posts (Atom)