CREATE PROCEDURE interestClub() SELECT name FROM people_interests WHERE interests && interests LIKE "%drawing%" AND interests && interests LIKE "%reading%" ORDER BY name
11 February 2018
interestClub
My solution:
Labels:
Arcade,
CodeSignal,
Databases,
MySQL,
Specialties
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;
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]$";
Subscribe to:
Posts (Atom)