11 February 2018

interestClub

My solution:
CREATE PROCEDURE interestClub() 
  SELECT name 
  FROM   people_interests 
  WHERE  interests && interests LIKE "%drawing%" 
         AND interests && interests LIKE "%reading%" 
  ORDER  BY name 

31 January 2018

The PADS

My solution:
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; 

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; 

Employee Salaries

My solution:
SELECT name 
FROM   Employee 
WHERE  salary > 2000 
       AND months < 10 
ORDER  BY employee_id; 

Employee Names

My solution:
SELECT name 
FROM   Employee 
ORDER  BY name; 

Higher Than 75 Marks

My solution:
SELECT Name 
FROM   STUDENTS 
WHERE  Marks > 75 
ORDER  BY RIGHT(Name, 3), 
          ID; 

Weather Observation Station 12

My solution:
SELECT DISTINCT CITY 
FROM   STATION 
WHERE  CITY REGEXP "^[^AEIOU].*[^aeiou]$";